golfstream
Новичок
Всем доброго времени суток !
Вывожу данные в шаблон:
В итоге, например возвращается 4 позиции, и во вкладке Doctrine панели app_dev показывает тоже 4 запроса:
Если вернется 10 позиций, то будет 10 запросов с разными параметрами id, время соответственно растет тоже.
Почему так происходит, или это нормально?
Спасибо.
P.S Тем, кто читал ранее.. Прошу прощения ошибся.
Вывожу данные в шаблон:
Код:
public function showAction(Request $request)
{
$em = $this->getDoctrine()->getManager();
$session = $request->getSession();
$cart = $em->getRepository('AppShopBundle:Cart')->findBy(array('user_token' => $session->get('token')));
return $this->render('cart/index.html.twig', array(
'cart' => $cart,
));
}
В итоге, например возвращается 4 позиции, и во вкладке Doctrine панели app_dev показывает тоже 4 запроса:
3 0.63 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.enabled AS enabled_4, t0.created_at AS created_at_5, t0.category_id AS category_id_6, t0.manufacturer_id AS manufacturer_id_7 FROM product t0 WHERE t0.id = ?
Parameters: [0 => 2]
4 0.78 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.enabled AS enabled_4, t0.created_at AS created_at_5, t0.category_id AS category_id_6, t0.manufacturer_id AS manufacturer_id_7 FROM product t0 WHERE t0.id = ?
Parameters: [0 => 3]
5 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.enabled AS enabled_4, t0.created_at AS created_at_5, t0.category_id AS category_id_6, t0.manufacturer_id AS manufacturer_id_7 FROM product t0 WHERE t0.id = ?
Parameters: [0 => 4]
6 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.enabled AS enabled_4, t0.created_at AS created_at_5, t0.category_id AS category_id_6, t0.manufacturer_id AS manufacturer_id_7 FROM product t0 WHERE t0.id = ?
Parameters: [0 => 1]
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.enabled AS enabled_4, t0.created_at AS created_at_5, t0.category_id AS category_id_6, t0.manufacturer_id AS manufacturer_id_7 FROM product t0 WHERE t0.id = ?
Parameters: [0 => 2]
4 0.78 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.enabled AS enabled_4, t0.created_at AS created_at_5, t0.category_id AS category_id_6, t0.manufacturer_id AS manufacturer_id_7 FROM product t0 WHERE t0.id = ?
Parameters: [0 => 3]
5 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.enabled AS enabled_4, t0.created_at AS created_at_5, t0.category_id AS category_id_6, t0.manufacturer_id AS manufacturer_id_7 FROM product t0 WHERE t0.id = ?
Parameters: [0 => 4]
6 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.enabled AS enabled_4, t0.created_at AS created_at_5, t0.category_id AS category_id_6, t0.manufacturer_id AS manufacturer_id_7 FROM product t0 WHERE t0.id = ?
Parameters: [0 => 1]
Если вернется 10 позиций, то будет 10 запросов с разными параметрами id, время соответственно растет тоже.
Почему так происходит, или это нормально?
Спасибо.
P.S Тем, кто читал ранее.. Прошу прощения ошибся.
Последнее редактирование: