Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.slug AS slug_5,
  t0.unicity AS unicity_6,
  t0.adaptercontent_id AS adaptercontent_id_7
FROM
  category t0
  INNER JOIN category_subcategory ON t0.id = category_subcategory.category_id
WHERE
  category_subcategory.subcategory_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.slug AS slug_5, t0.unicity AS unicity_6, t0.adaptercontent_id AS adaptercontent_id_7 FROM category t0 INNER JOIN category_subcategory ON t0.id = category_subcategory.category_id WHERE category_subcategory.subcategory_id = 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.slug AS slug_4,
  t0.image AS image_5,
  t0.unicity AS unicity_6
FROM
  subcategory t0
  INNER JOIN category_subcategory ON t0.id = category_subcategory.subcategory_id
WHERE
  category_subcategory.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.image AS image_5, t0.unicity AS unicity_6 FROM subcategory t0 INNER JOIN category_subcategory ON t0.id = category_subcategory.subcategory_id WHERE category_subcategory.category_id = 66;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.description AS description_2,
  s0_.slug AS slug_3,
  s0_.image AS image_4,
  s0_.unicity AS unicity_5
FROM
  subcategory s0_
  INNER JOIN product_subcategory p2_ ON s0_.id = p2_.subcategory_id
  INNER JOIN product p1_ ON p1_.id = p2_.product_id
  LEFT JOIN service s3_ ON p1_.id = s3_.id
  LEFT JOIN marchandise m4_ ON p1_.id = m4_.id
  INNER JOIN company c5_ ON p1_.company_id = c5_.id
  LEFT JOIN userrv u6_ ON c5_.id = u6_.id
  INNER JOIN company_category c8_ ON c5_.id = c8_.company_id
  INNER JOIN category c7_ ON c7_.id = c8_.category_id
WHERE
  u6_.id = ?

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.slug AS slug_3, s0_.image AS image_4, s0_.unicity AS unicity_5 FROM subcategory s0_ INNER JOIN product_subcategory p2_ ON s0_.id = p2_.subcategory_id INNER JOIN product p1_ ON p1_.id = p2_.product_id LEFT JOIN service s3_ ON p1_.id = s3_.id LEFT JOIN marchandise m4_ ON p1_.id = m4_.id INNER JOIN company c5_ ON p1_.company_id = c5_.id LEFT JOIN userrv u6_ ON c5_.id = u6_.id INNER JOIN company_category c8_ ON c5_.id = c8_.company_id INNER JOIN category c7_ ON c7_.id = c8_.category_id WHERE u6_.id = 261;

SELECT
  t0.id AS id_3,
  t0.name AS name_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  t0.description AS description_7,
  t0.niveau AS niveau_8,
  t0.origin AS origin_9,
  t0.slug AS slug_10,
  t0.certification AS certification_11,
  t0.price AS price_12,
  t0.currency AS currency_13,
  t0.wantevaluation AS wantevaluation_14,
  t0.gaearecommanded AS gaearecommanded_15,
  t0.creation_date AS creation_date_16,
  t0.updated_date AS updated_date_17,
  t0.image AS image_18,
  t0.type AS type_19,
  t0.unicity AS unicity_20,
  t0.owner AS owner_21,
  t0.company_id AS company_id_22,
  t0.category_id AS category_id_23,
  t0.adaptercontent_id AS adaptercontent_id_24,
  t0.discr,
  t1.serviceduration AS serviceduration_25,
  t2.packaging AS packaging_26,
  t2.quantity AS quantity_27,
  t2.weight AS weight_28,
  t2.weightunit AS weightunit_29,
  t2.volume AS volume_30,
  t2.volumeunit AS volumeunit_31,
  t2.height AS height_32,
  t2.width AS width_33,
  t2.depth AS depth_34,
  t2.lengthunit AS lengthunit_35,
  t2.sell_type AS sell_type_36
FROM
  product t0
  LEFT JOIN service t1 ON t0.id = t1.id
  LEFT JOIN marchandise t2 ON t0.id = t2.id
WHERE
  t0.company_id = ?

SELECT t0.id AS id_3, t0.name AS name_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.description AS description_7, t0.niveau AS niveau_8, t0.origin AS origin_9, t0.slug AS slug_10, t0.certification AS certification_11, t0.price AS price_12, t0.currency AS currency_13, t0.wantevaluation AS wantevaluation_14, t0.gaearecommanded AS gaearecommanded_15, t0.creation_date AS creation_date_16, t0.updated_date AS updated_date_17, t0.image AS image_18, t0.type AS type_19, t0.unicity AS unicity_20, t0.owner AS owner_21, t0.company_id AS company_id_22, t0.category_id AS category_id_23, t0.adaptercontent_id AS adaptercontent_id_24, t0.discr, t1.serviceduration AS serviceduration_25, t2.packaging AS packaging_26, t2.quantity AS quantity_27, t2.weight AS weight_28, t2.weightunit AS weightunit_29, t2.volume AS volume_30, t2.volumeunit AS volumeunit_31, t2.height AS height_32, t2.width AS width_33, t2.depth AS depth_34, t2.lengthunit AS lengthunit_35, t2.sell_type AS sell_type_36 FROM product t0 LEFT JOIN service t1 ON t0.id = t1.id LEFT JOIN marchandise t2 ON t0.id = t2.id WHERE t0.company_id = 261;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.slug AS slug_4,
  t0.image AS image_5,
  t0.unicity AS unicity_6
FROM
  subcategory t0
  INNER JOIN product_subcategory ON t0.id = product_subcategory.subcategory_id
WHERE
  product_subcategory.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.image AS image_5, t0.unicity AS unicity_6 FROM subcategory t0 INNER JOIN product_subcategory ON t0.id = product_subcategory.subcategory_id WHERE product_subcategory.product_id = 143;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.slug AS slug_5,
  t0.unicity AS unicity_6,
  t0.adaptercontent_id AS adaptercontent_id_7
FROM
  category t0
  INNER JOIN company_category ON t0.id = company_category.category_id
WHERE
  company_category.company_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.slug AS slug_5, t0.unicity AS unicity_6, t0.adaptercontent_id AS adaptercontent_id_7 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = 261;

SELECT
  t0.id AS id_1,
  t0.weight AS weight_2,
  t0.volume AS volume_3,
  t0.volumeunit AS volumeunit_4,
  t0.height AS height_5,
  t0.width AS width_6,
  t0.depth AS depth_7,
  t0.weightunit AS weightunit_8,
  t0.lengthunit AS lengthunit_9,
  t0.marchandise_id AS marchandise_id_10
FROM
  size t0
WHERE
  t0.marchandise_id = ?

SELECT t0.id AS id_1, t0.weight AS weight_2, t0.volume AS volume_3, t0.volumeunit AS volumeunit_4, t0.height AS height_5, t0.width AS width_6, t0.depth AS depth_7, t0.weightunit AS weightunit_8, t0.lengthunit AS lengthunit_9, t0.marchandise_id AS marchandise_id_10 FROM size t0 WHERE t0.marchandise_id = 144;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.slug AS slug_5,
  t0.unicity AS unicity_6,
  t0.adaptercontent_id AS adaptercontent_id_7
FROM
  category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.slug AS slug_5, t0.unicity AS unicity_6, t0.adaptercontent_id AS adaptercontent_id_7 FROM category t0 WHERE t0.slug = 'compensation-carbone' LIMIT 1;

SELECT
  t1.id AS id_2,
  t1.gaeaUserId AS gaeaUserId_3,
  t1.username AS username_4,
  t1.role AS role_5,
  t1.token AS token_6,
  t1.emailValidated AS emailValidated_7,
  t1.actived AS actived_8,
  t1.inscription_date AS inscription_date_9,
  t1.avatar AS avatar_10,
  t1.connected AS connected_11,
  t1.firstname AS firstname_12,
  t1.lastname AS lastname_13,
  t0.name AS name_14,
  t0.certification AS certification_15,
  t0.niveau AS niveau_16,
  t0.influencezone AS influencezone_17,
  t0.street AS street_18,
  t0.streetnumber AS streetnumber_19,
  t0.postcode AS postcode_20,
  t0.city AS city_21,
  t0.region AS region_22,
  t0.country AS country_23,
  t0.phone AS phone_24,
  t0.wantevaluation AS wantevaluation_25,
  t0.description AS description_26,
  t0.vision AS vision_27,
  t0.socialreason AS socialreason_28,
  t0.urlwebsite AS urlwebsite_29,
  t0.urlfacebook AS urlfacebook_30,
  t0.urltwitter AS urltwitter_31,
  t0.urllinkedin AS urllinkedin_32,
  t0.slug AS slug_33,
  t0.starting_date AS starting_date_34,
  t0.package AS package_35,
  t0.image AS image_36,
  t0.latitude AS latitude_37,
  t0.longtitude AS longtitude_38,
  t0.activated AS activated_39,
  t1.discr
FROM
  company t0
  INNER JOIN userrv t1 ON t0.id = t1.id
  INNER JOIN company_category ON t0.id = company_category.company_id
WHERE
  company_category.category_id = ?

SELECT t1.id AS id_2, t1.gaeaUserId AS gaeaUserId_3, t1.username AS username_4, t1.role AS role_5, t1.token AS token_6, t1.emailValidated AS emailValidated_7, t1.actived AS actived_8, t1.inscription_date AS inscription_date_9, t1.avatar AS avatar_10, t1.connected AS connected_11, t1.firstname AS firstname_12, t1.lastname AS lastname_13, t0.name AS name_14, t0.certification AS certification_15, t0.niveau AS niveau_16, t0.influencezone AS influencezone_17, t0.street AS street_18, t0.streetnumber AS streetnumber_19, t0.postcode AS postcode_20, t0.city AS city_21, t0.region AS region_22, t0.country AS country_23, t0.phone AS phone_24, t0.wantevaluation AS wantevaluation_25, t0.description AS description_26, t0.vision AS vision_27, t0.socialreason AS socialreason_28, t0.urlwebsite AS urlwebsite_29, t0.urlfacebook AS urlfacebook_30, t0.urltwitter AS urltwitter_31, t0.urllinkedin AS urllinkedin_32, t0.slug AS slug_33, t0.starting_date AS starting_date_34, t0.package AS package_35, t0.image AS image_36, t0.latitude AS latitude_37, t0.longtitude AS longtitude_38, t0.activated AS activated_39, t1.discr FROM company t0 INNER JOIN userrv t1 ON t0.id = t1.id INNER JOIN company_category ON t0.id = company_category.company_id WHERE company_category.category_id = 66;

SELECT
  t0.id AS id_1,
  t0.is_accepted AS is_accepted_2,
  t0.user AS user_3,
  t0.friend AS friend_4
FROM
  friendship t0
WHERE
  t0.friend IN (?, ?, ?, ?)

SELECT t0.id AS id_1, t0.is_accepted AS is_accepted_2, t0.user AS user_3, t0.friend AS friend_4 FROM friendship t0 WHERE t0.friend IN (261, 387, 525, 527);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.slug AS slug_5,
  t0.unicity AS unicity_6,
  t0.adaptercontent_id AS adaptercontent_id_7
FROM
  category t0
WHERE
  t0.unicity = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.slug AS slug_5, t0.unicity AS unicity_6, t0.adaptercontent_id AS adaptercontent_id_7 FROM category t0 WHERE t0.unicity = 1;

SELECT
  t0.id AS id_1,
  t0.is_accepted AS is_accepted_2,
  t0.user AS user_3,
  t0.friend AS friend_4
FROM
  friendship t0
WHERE
  t0.user IN (?, ?, ?, ?)

SELECT t0.id AS id_1, t0.is_accepted AS is_accepted_2, t0.user AS user_3, t0.friend AS friend_4 FROM friendship t0 WHERE t0.user IN (261, 387, 525, 527);