Query Metrics
93
Database Queries
9
Different statements
29.10 ms
Query time
6
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.95 ms |
SELECT c0_.id AS id_0, c0_.siren AS siren_1, c0_.contact_name AS contact_name_2, c0_.contact_phone AS contact_phone_3, c0_.company_name AS company_name_4, c0_.fax AS fax_5, c0_.website AS website_6, c0_.contact_civility AS contact_civility_7, c0_.is_accept_condition AS is_accept_condition_8, c0_.company_slug AS company_slug_9, c0_.description AS description_10, c0_.image AS image_11, c0_.is_confirmed AS is_confirmed_12, c0_.kbis AS kbis_13, c0_.conditions_vente AS conditions_vente_14, c0_.strip_id AS strip_id_15, c0_.stripe_account AS stripe_account_16, c0_.first_name AS first_name_17, c0_.contact_birthday AS contact_birthday_18, c0_.country AS country_19, c0_.mango_id AS mango_id_20, c0_.is_valid_document AS is_valid_document_21, c0_.type AS type_22, c0_.is_editor_guide AS is_editor_guide_23, c0_.paiement_activ AS paiement_activ_24, c0_.commission_active AS commission_active_25, c0_.statu_con AS statu_con_26, c0_.etat_network AS etat_network_27, c0_.created_at AS created_at_28, c0_.is_direct_reservation_mode AS is_direct_reservation_mode_29, c0_.stripe_id AS stripe_id_30, c0_.stripe_account_id AS stripe_account_id_31, c0_.roles AS roles_32, c0_.email AS email_33, c0_.password AS password_34, c0_.adress AS adress_35, c0_.zip_code AS zip_code_36, c0_.city AS city_37, p1_.id AS id_38, p1_.name AS name_39, p1_.text AS text_40, p1_.price AS price_41, p1_.quantity AS quantity_42, p1_.product_slug AS product_slug_43, p1_.percent_deposit AS percent_deposit_44, p1_.deadline AS deadline_45, p1_.sizes AS sizes_46, p1_.colors AS colors_47, p1_.size_ring AS size_ring_48, p1_.nb_guest AS nb_guest_49, p1_.youtube_video AS youtube_video_50, p1_.is_activated AS is_activated_51, p1_.is_desactivated_by_admin AS is_desactivated_by_admin_52, p1_.mode_livraison AS mode_livraison_53, p1_.frais_livraison AS frais_livraison_54, p1_.weight AS weight_55, p1_.transporteurs AS transporteurs_56, p1_.code_promo AS code_promo_57, p1_.code_promo_euro AS code_promo_euro_58, p1_.template AS template_59, p1_.taxe_sejour AS taxe_sejour_60, p1_.prix_caution AS prix_caution_61, p1_.longitude AS longitude_62, p1_.latitude AS latitude_63, p1_.spring_price AS spring_price_64, p1_.summer_price AS summer_price_65, p1_.autumn_price AS autumn_price_66, p1_.winter_price AS winter_price_67, p1_.week_end_price AS week_end_price_68, p1_.city_localisation AS city_localisation_69, p1_.nb_chambre AS nb_chambre_70, p1_.night_min AS night_min_71, a2_.id AS id_72, a2_.service_quality AS service_quality_73, a2_.fiability AS fiability_74, a2_.price AS price_75, a2_.speed AS speed_76, a2_.text AS text_77, a2_.conform_description AS conform_description_78, a2_.communication AS communication_79, a2_.global_note AS global_note_80, a2_.created_at AS created_at_81, a2_.response_company AS response_company_82, a2_.is_desactivated_by_admin AS is_desactivated_by_admin_83, p1_.company_id AS company_id_84, p1_.pack_id AS pack_id_85, p1_.type_location_id AS type_location_id_86, p1_.type_prestation_id AS type_prestation_id_87, p1_.tva_id AS tva_id_88, p1_.type_hebergements_id AS type_hebergements_id_89, p1_.type_activity_id AS type_activity_id_90, p1_.caracteristique_vehicule_id AS caracteristique_vehicule_id_91, p1_.commune_id AS commune_id_92, a2_.product_id AS product_id_93, a2_.client_id AS client_id_94 FROM company c0_ LEFT JOIN product p1_ ON c0_.id = p1_.company_id LEFT JOIN avis a2_ ON p1_.id = a2_.product_id WHERE c0_.is_confirmed = 1 AND c0_.is_valid_document = 1 AND p1_.is_activated = 1 ORDER BY a2_.global_note DESC
Parameters:
[] |
| 2 | 0.41 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
13
]
|
| 3 | 0.33 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
28
]
|
| 4 | 0.21 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
29
]
|
| 5 | 0.21 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
19
]
|
| 6 | 0.50 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
30
]
|
| 7 | 0.21 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
31
]
|
| 8 | 0.20 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
25
]
|
| 9 | 0.19 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
59
]
|
| 10 | 0.18 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
47
]
|
| 11 | 0.19 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
68
]
|
| 12 | 0.18 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
71
]
|
| 13 | 0.17 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
34
]
|
| 14 | 0.19 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
35
]
|
| 15 | 0.17 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
48
]
|
| 16 | 0.17 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
36
]
|
| 17 | 0.17 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
49
]
|
| 18 | 0.17 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
39
]
|
| 19 | 0.17 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
37
]
|
| 20 | 0.18 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
75
]
|
| 21 | 0.17 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
83
]
|
| 22 | 0.17 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
41
]
|
| 23 | 0.21 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
38
]
|
| 24 | 0.18 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
89
]
|
| 25 | 0.18 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
52
]
|
| 26 | 0.18 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
53
]
|
| 27 | 0.17 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
57
]
|
| 28 | 0.19 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
64
]
|
| 29 | 0.17 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
70
]
|
| 30 | 0.28 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
81
]
|
| 31 | 0.19 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
72
]
|
| 32 | 0.18 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
73
]
|
| 33 | 0.18 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
74
]
|
| 34 | 0.17 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
76
]
|
| 35 | 0.17 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
77
]
|
| 36 | 0.60 ms |
SELECT t0.id AS id_1, t0.siren AS siren_2, t0.contact_name AS contact_name_3, t0.contact_phone AS contact_phone_4, t0.company_name AS company_name_5, t0.fax AS fax_6, t0.website AS website_7, t0.contact_civility AS contact_civility_8, t0.is_accept_condition AS is_accept_condition_9, t0.company_slug AS company_slug_10, t0.description AS description_11, t0.image AS image_12, t0.is_confirmed AS is_confirmed_13, t0.kbis AS kbis_14, t0.conditions_vente AS conditions_vente_15, t0.strip_id AS strip_id_16, t0.stripe_account AS stripe_account_17, t0.first_name AS first_name_18, t0.contact_birthday AS contact_birthday_19, t0.country AS country_20, t0.mango_id AS mango_id_21, t0.is_valid_document AS is_valid_document_22, t0.type AS type_23, t0.is_editor_guide AS is_editor_guide_24, t0.paiement_activ AS paiement_activ_25, t0.commission_active AS commission_active_26, t0.statu_con AS statu_con_27, t0.etat_network AS etat_network_28, t0.created_at AS created_at_29, t0.is_direct_reservation_mode AS is_direct_reservation_mode_30, t0.stripe_id AS stripe_id_31, t0.stripe_account_id AS stripe_account_id_32, t0.roles AS roles_33, t0.email AS email_34, t0.password AS password_35, t0.adress AS adress_36, t0.zip_code AS zip_code_37, t0.city AS city_38 FROM company t0 WHERE t0.is_confirmed = ? AND t0.is_valid_document = ?
Parameters:
[ 1 1 ] |
| 37 | 0.61 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = ? AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = ? ORDER BY p0_.id DESC LIMIT 1
Parameters:
[ 218 1 ] |
| 38 | 0.22 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.product_id AS product_id_3 FROM photos t0 WHERE t0.product_id = ?
Parameters:
[
29
]
|
| 39 | 0.46 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = ? AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = ? ORDER BY p0_.id DESC LIMIT 1
Parameters:
[ 224 1 ] |
| 40 | 0.20 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.product_id AS product_id_3 FROM photos t0 WHERE t0.product_id = ?
Parameters:
[
19
]
|
| 41 | 0.44 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = ? AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = ? ORDER BY p0_.id DESC LIMIT 1
Parameters:
[ 225 1 ] |
| 42 | 0.19 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.product_id AS product_id_3 FROM photos t0 WHERE t0.product_id = ?
Parameters:
[
25
]
|
| 43 | 0.54 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = ? AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = ? ORDER BY p0_.id DESC LIMIT 1
Parameters:
[ 226 1 ] |
| 44 | 0.20 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.product_id AS product_id_3 FROM photos t0 WHERE t0.product_id = ?
Parameters:
[
31
]
|
| 45 | 0.46 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = ? AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = ? ORDER BY p0_.id DESC LIMIT 1
Parameters:
[ 235 1 ] |
| 46 | 0.27 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.product_id AS product_id_3 FROM photos t0 WHERE t0.product_id = ?
Parameters:
[
59
]
|
| 47 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sub_category_slug AS sub_category_slug_3, t0.is_suivi AS is_suivi_4, t0.is_clothing AS is_clothing_5, t0.is_color AS is_color_6, t0.is_nb_guest AS is_nb_guest_7, t0.image AS image_8, t0.is_clothing_ring AS is_clothing_ring_9, t0.is_service AS is_service_10, t0.is_fairepart AS is_fairepart_11, t0.is_vehicle AS is_vehicle_12 FROM sub_category t0 ORDER BY t0.id DESC
Parameters:
[] |
| 48 | 0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sub_category_slug AS sub_category_slug_3, t0.is_suivi AS is_suivi_4, t0.is_clothing AS is_clothing_5, t0.is_color AS is_color_6, t0.is_nb_guest AS is_nb_guest_7, t0.image AS image_8, t0.is_clothing_ring AS is_clothing_ring_9, t0.is_service AS is_service_10, t0.is_fairepart AS is_fairepart_11, t0.is_vehicle AS is_vehicle_12 FROM sub_category t0 ORDER BY t0.id DESC
Parameters:
[] |
| 49 | 0.38 ms |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.numero AS numero_2 FROM department d0_ LEFT JOIN product_department p2_ ON d0_.id = p2_.department_id LEFT JOIN product p1_ ON p1_.id = p2_.product_id
Parameters:
[] |
| 50 | 0.37 ms |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.numero AS numero_2 FROM department d0_ LEFT JOIN product_department p2_ ON d0_.id = p2_.department_id LEFT JOIN product p1_ ON p1_.id = p2_.product_id
Parameters:
[] |
| 51 | 0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sub_category_slug AS sub_category_slug_3, t0.is_suivi AS is_suivi_4, t0.is_clothing AS is_clothing_5, t0.is_color AS is_color_6, t0.is_nb_guest AS is_nb_guest_7, t0.image AS image_8, t0.is_clothing_ring AS is_clothing_ring_9, t0.is_service AS is_service_10, t0.is_fairepart AS is_fairepart_11, t0.is_vehicle AS is_vehicle_12 FROM sub_category t0 ORDER BY t0.id DESC
Parameters:
[] |
| 52 | 0.52 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = ? AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = ? ORDER BY p0_.id DESC LIMIT 3
Parameters:
[ 241 1 ] |
| 53 | 0.49 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = ? AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = ? ORDER BY p0_.id DESC LIMIT 3
Parameters:
[ 241 1 ] |
| 54 | 0.22 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.product_id AS product_id_3 FROM photos t0 WHERE t0.product_id = ?
Parameters:
[
49
]
|
| 55 | 0.20 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.product_id AS product_id_3 FROM photos t0 WHERE t0.product_id = ?
Parameters:
[
48
]
|
| 56 | 0.21 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.product_id AS product_id_3 FROM photos t0 WHERE t0.product_id = ?
Parameters:
[
41
]
|
| 57 | 0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.slug AS slug_4 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = ?
Parameters:
[
241
]
|
| 58 | 0.60 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = ? AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = ? ORDER BY p0_.id DESC LIMIT 3
Parameters:
[ 239 1 ] |
| 59 | 0.45 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = ? AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = ? ORDER BY p0_.id DESC LIMIT 3
Parameters:
[ 239 1 ] |
| 60 | 0.21 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.product_id AS product_id_3 FROM photos t0 WHERE t0.product_id = ?
Parameters:
[
39
]
|
| 61 | 0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.slug AS slug_4 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = ?
Parameters:
[
239
]
|
| 62 | 0.45 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = ? AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = ? ORDER BY p0_.id DESC LIMIT 3
Parameters:
[ 242 1 ] |
| 63 | 0.46 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = ? AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = ? ORDER BY p0_.id DESC LIMIT 3
Parameters:
[ 242 1 ] |
| 64 | 0.23 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.product_id AS product_id_3 FROM photos t0 WHERE t0.product_id = ?
Parameters:
[
37
]
|
| 65 | 0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.slug AS slug_4 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = ?
Parameters:
[
242
]
|
| 66 | 0.51 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = ? AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = ? ORDER BY p0_.id DESC LIMIT 3
Parameters:
[ 258 1 ] |
| 67 | 0.50 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = ? AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = ? ORDER BY p0_.id DESC LIMIT 3
Parameters:
[ 258 1 ] |
| 68 | 0.21 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.product_id AS product_id_3 FROM photos t0 WHERE t0.product_id = ?
Parameters:
[
77
]
|
| 69 | 0.21 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.product_id AS product_id_3 FROM photos t0 WHERE t0.product_id = ?
Parameters:
[
76
]
|
| 70 | 0.23 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.product_id AS product_id_3 FROM photos t0 WHERE t0.product_id = ?
Parameters:
[
75
]
|
| 71 | 0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.slug AS slug_4 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = ?
Parameters:
[
258
]
|
| 72 | 0.45 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = ? AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = ? ORDER BY p0_.id DESC LIMIT 3
Parameters:
[ 260 1 ] |
| 73 | 0.45 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = ? AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = ? ORDER BY p0_.id DESC LIMIT 3
Parameters:
[ 260 1 ] |
| 74 | 0.20 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.product_id AS product_id_3 FROM photos t0 WHERE t0.product_id = ?
Parameters:
[
83
]
|
| 75 | 0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.slug AS slug_4 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = ?
Parameters:
[
260
]
|
| 76 | 0.50 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = ? AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = ? ORDER BY p0_.id DESC LIMIT 3
Parameters:
[ 244 1 ] |
| 77 | 0.46 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = ? AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = ? ORDER BY p0_.id DESC LIMIT 3
Parameters:
[ 244 1 ] |
| 78 | 0.21 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.product_id AS product_id_3 FROM photos t0 WHERE t0.product_id = ?
Parameters:
[
53
]
|
| 79 | 0.19 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.product_id AS product_id_3 FROM photos t0 WHERE t0.product_id = ?
Parameters:
[
52
]
|
| 80 | 0.21 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.product_id AS product_id_3 FROM photos t0 WHERE t0.product_id = ?
Parameters:
[
38
]
|
| 81 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.slug AS slug_4 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = ?
Parameters:
[
244
]
|
| 82 | 0.45 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = ? AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = ? ORDER BY p0_.id DESC LIMIT 3
Parameters:
[ 265 1 ] |
| 83 | 0.45 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = ? AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = ? ORDER BY p0_.id DESC LIMIT 3
Parameters:
[ 265 1 ] |
| 84 | 0.21 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.product_id AS product_id_3 FROM photos t0 WHERE t0.product_id = ?
Parameters:
[
89
]
|
| 85 | 0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.slug AS slug_4 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = ?
Parameters:
[
265
]
|
| 86 | 0.43 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = ? AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = ? ORDER BY p0_.id DESC LIMIT 3
Parameters:
[ 249 1 ] |
| 87 | 0.42 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = ? AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = ? ORDER BY p0_.id DESC LIMIT 3
Parameters:
[ 249 1 ] |
| 88 | 0.20 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.product_id AS product_id_3 FROM photos t0 WHERE t0.product_id = ?
Parameters:
[
57
]
|
| 89 | 0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.slug AS slug_4 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = ?
Parameters:
[
249
]
|
| 90 | 0.44 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = ? AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = ? ORDER BY p0_.id DESC LIMIT 3
Parameters:
[ 252 1 ] |
| 91 | 0.46 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = ? AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = ? ORDER BY p0_.id DESC LIMIT 3
Parameters:
[ 252 1 ] |
| 92 | 0.20 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.product_id AS product_id_3 FROM photos t0 WHERE t0.product_id = ?
Parameters:
[
64
]
|
| 93 | 0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.slug AS slug_4 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = ?
Parameters:
[
252
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Company |
|
| App\Entity\Product |
|
| App\Entity\Avis | No errors. |
| App\Entity\Pack | No errors. |
| App\Entity\TypeLocation | No errors. |
| App\Entity\TypePrestation | No errors. |
| App\Entity\Tva | No errors. |
| App\Entity\TypeHebergement | No errors. |
| App\Entity\ActivityType | No errors. |
| App\Entity\CaracteristiqueVehicule | No errors. |
| App\Entity\Commune | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Messaging | No errors. |
| App\Entity\PlanningCompany | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Payout | No errors. |
| App\Entity\Abonnement |
|
| App\Entity\AnnonceCompany | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\ReseauSociaux\Publication | No errors. |
| App\Entity\ReseauSociaux\Conversation |
|
| App\Entity\ReseauSociaux\Message | No errors. |
| App\Entity\ReseauSociaux\Espace | No errors. |
| App\Entity\ReseauSociaux\Notifications | No errors. |
| App\Entity\ReseauSociaux\PostLike | No errors. |
| App\Entity\PendingLocation | No errors. |
| App\Entity\PendingReservation | No errors. |
| App\Entity\Photos | No errors. |
| App\Entity\Department | No errors. |
| App\Entity\CommandProduct | No errors. |
| App\Entity\ProductPercent | No errors. |
| App\Entity\ContactProduct | No errors. |
| App\Entity\ProductOption | No errors. |
| App\Entity\SubCategory | No errors. |
| App\Entity\ProductDescription | No errors. |
| App\Entity\Location |
|
| App\Entity\Reservation | No errors. |
| App\Entity\Caution | No errors. |
| App\Entity\Participant | No errors. |
| App\Entity\Chambre | No errors. |
| App\Entity\Caracteristic | No errors. |
| App\Entity\Equipment | No errors. |
| App\Entity\LangueHote | No errors. |
| App\Entity\TypeLocalisation | No errors. |
| App\Entity\Security | No errors. |
| App\Entity\ProductReduction | No errors. |
| App\Entity\ProgrammingDayPrice | No errors. |
| App\Entity\ProductAgenda | No errors. |
| App\Entity\ProductAutoReduction |
|
| App\Entity\ProductPeriodPrice | No errors. |
| App\Entity\TarifDegressif | No errors. |
| App\Entity\EquipementsCuisine | No errors. |
| App\Entity\SalleDeBain | No errors. |
| App\Entity\AccessoiresDeChambre | No errors. |
| App\Entity\MobilierExterieur | No errors. |
| App\Entity\Annonce | No errors. |