INFO
10:19:34
|
request
|
Matched route "product_details". |
INFO
10:19:34
|
security
|
Populated the TokenStorage with an anonymous Token. |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "Http\HttplugBundle\Discovery\ConfiguredClientsStrategy::onEvent". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "Http\HttplugBundle\Collector\PluginClientFactoryListener::onEvent". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\FragmentListener::onKernelRequest". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\ResolveControllerNameSubscriber::onKernelRequest". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "FOS\RestBundle\EventListener\BodyListener::onKernelRequest". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelRequest". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest". |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.text AS text_2, t0.link AS link_3, t0.background_color AS background_color_4, t0.text_color AS text_color_5, t0.enabled AS enabled_6, t0.closeable AS closeable_7 FROM top_banner_setting t0 |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.name AS name_2, t0.image_path AS image_path_3, t0.mobile_image_path AS mobile_image_path_4, t0.cover_image_path AS cover_image_path_5, t0.mobile_cover_image_path AS mobile_cover_image_path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.slug AS slug_9 FROM categories t0 |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.name AS name_3, t0.description AS description_4, t0.price AS price_5, t0.compare_at_price AS compare_at_price_6, t0.price_currency AS price_currency_7, t0.inventory_level AS inventory_level_8, t0.weight AS weight_9, t0.activated_at AS activated_at_10, t0.deactivated_at AS deactivated_at_11, t0.back_order_enabled AS back_order_enabled_12, t0.back_order_alert AS back_order_alert_13, t0.hide_product AS hide_product_14, t0.design_label AS design_label_15, t0.product_type AS product_type_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.slug AS slug_19, t0.primary_image_id AS primary_image_id_20, t0.size_guide_image_id AS size_guide_image_id_21, t0.design_thumbnail_id AS design_thumbnail_id_22, t0.group_id AS group_id_23, t0.design_group_id AS design_group_id_24 FROM products t0 WHERE t0.sku = ? LIMIT 1 |
DEBUG
10:19:34
|
event
|
Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelController". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelController". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RequestDataCollector::onKernelController". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController". |
DEBUG
10:19:34
|
doctrine
|
SELECT r0_.id AS id_0, r0_.date_published AS date_published_1, r0_.date_unpublished AS date_unpublished_2, r0_.title AS title_3, r0_.body AS body_4, r0_.rating AS rating_5, r0_.created_at AS created_at_6, r0_.updated_at AS updated_at_7, u1_.username AS username_8, u1_.username_canonical AS username_canonical_9, u1_.email AS email_10, u1_.email_canonical AS email_canonical_11, u1_.enabled AS enabled_12, u1_.salt AS salt_13, u1_.password AS password_14, u1_.last_login AS last_login_15, u1_.confirmation_token AS confirmation_token_16, u1_.password_requested_at AS password_requested_at_17, u1_.roles AS roles_18, u1_.id AS id_19, u1_.first_name AS first_name_20, u1_.last_name AS last_name_21, u1_.mobile_no AS mobile_no_22, u1_.facebook_id AS facebook_id_23, u1_.facebook_access_token AS facebook_access_token_24, u1_.facebook_new_user AS facebook_new_user_25, u1_.date_of_birth AS date_of_birth_26, u1_.gender AS gender_27, u1_.created_at AS created_at_28, u1_.updated_at AS updated_at_29, r0_.product_id AS product_id_30, r0_.user_id AS user_id_31, u1_.cart_id AS cart_id_32 FROM reviews r0_ INNER JOIN users u1_ ON r0_.user_id = u1_.id WHERE r0_.product_id = 4 AND r0_.date_published IS NOT NULL |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.created_time AS created_time_2, t0.body AS body_3, t0.rating AS rating_4, t0.facebook_user_id AS facebook_user_id_5, t0.facebook_username AS facebook_username_6 FROM facebook_reviews t0 INNER JOIN products_facebook_reviews ON t0.id = products_facebook_reviews.facebook_review_id WHERE products_facebook_reviews.product_id = ? ORDER BY t0.created_time DESC |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.price AS price_2, t0.price_currency AS price_currency_3, t0.inventory_level AS inventory_level_4, t0.weight AS weight_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.product_id AS product_id_8 FROM product_variants t0 WHERE t0.product_id = ? |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.slug AS slug_6, t0.attribute_id AS attribute_id_7 FROM attribute_values t0 INNER JOIN product_variants_attribute_values ON t0.id = product_variants_attribute_values.attribute_value_id WHERE product_variants_attribute_values.product_variant_id = ? |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.slug AS slug_6, t0.attribute_id AS attribute_id_7 FROM attribute_values t0 INNER JOIN product_variants_attribute_values ON t0.id = product_variants_attribute_values.attribute_value_id WHERE product_variants_attribute_values.product_variant_id = ? |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM product_design_group t0 WHERE t0.id = ? |
DEBUG
10:19:34
|
doctrine
|
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.label AS label_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4 FROM product_design_group p0_ WHERE p0_.label = 'heatpants' AND p0_.id <> 1 ORDER BY p0_.name ASC |
DEBUG
10:19:34
|
doctrine
|
SELECT p0_.id AS id_0, p0_.sku AS sku_1, p0_.name AS name_2, p0_.description AS description_3, p0_.price AS price_4, p0_.compare_at_price AS compare_at_price_5, p0_.price_currency AS price_currency_6, p0_.inventory_level AS inventory_level_7, p0_.weight AS weight_8, p0_.activated_at AS activated_at_9, p0_.deactivated_at AS deactivated_at_10, p0_.back_order_enabled AS back_order_enabled_11, p0_.back_order_alert AS back_order_alert_12, p0_.hide_product AS hide_product_13, p0_.design_label AS design_label_14, p0_.product_type AS product_type_15, p0_.created_at AS created_at_16, p0_.updated_at AS updated_at_17, p0_.slug AS slug_18, p0_.primary_image_id AS primary_image_id_19, p0_.size_guide_image_id AS size_guide_image_id_20, p0_.design_thumbnail_id AS design_thumbnail_id_21, p0_.group_id AS group_id_22, p0_.design_group_id AS design_group_id_23 FROM products p0_ LEFT JOIN product_bundle_items p1_ ON p0_.id = p1_.bundle_id WHERE p0_.product_type = 'bundle' AND p0_.activated_at IS NOT NULL AND (p1_.product_id = 4 OR p1_.product_group_id = 1) GROUP BY p0_.id |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.type AS type_2, t0.sequence_no AS sequence_no_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.bundle_id AS bundle_id_6, t0.product_id AS product_id_7, t0.product_group_id AS product_group_id_8, t0.group_default_product_id AS group_default_product_id_9 FROM product_bundle_items t0 WHERE t0.bundle_id = ? ORDER BY t0.sequence_no ASC |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.name AS name_3, t0.description AS description_4, t0.price AS price_5, t0.compare_at_price AS compare_at_price_6, t0.price_currency AS price_currency_7, t0.inventory_level AS inventory_level_8, t0.weight AS weight_9, t0.activated_at AS activated_at_10, t0.deactivated_at AS deactivated_at_11, t0.back_order_enabled AS back_order_enabled_12, t0.back_order_alert AS back_order_alert_13, t0.hide_product AS hide_product_14, t0.design_label AS design_label_15, t0.product_type AS product_type_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.slug AS slug_19, t0.primary_image_id AS primary_image_id_20, t0.size_guide_image_id AS size_guide_image_id_21, t0.design_thumbnail_id AS design_thumbnail_id_22, t0.group_id AS group_id_23, t0.design_group_id AS design_group_id_24 FROM products t0 WHERE t0.id = ? |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.price AS price_2, t0.price_currency AS price_currency_3, t0.inventory_level AS inventory_level_4, t0.weight AS weight_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.product_id AS product_id_8 FROM product_variants t0 WHERE t0.product_id = ? |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.name AS name_3, t0.description AS description_4, t0.price AS price_5, t0.compare_at_price AS compare_at_price_6, t0.price_currency AS price_currency_7, t0.inventory_level AS inventory_level_8, t0.weight AS weight_9, t0.activated_at AS activated_at_10, t0.deactivated_at AS deactivated_at_11, t0.back_order_enabled AS back_order_enabled_12, t0.back_order_alert AS back_order_alert_13, t0.hide_product AS hide_product_14, t0.design_label AS design_label_15, t0.product_type AS product_type_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.slug AS slug_19, t0.primary_image_id AS primary_image_id_20, t0.size_guide_image_id AS size_guide_image_id_21, t0.design_thumbnail_id AS design_thumbnail_id_22, t0.group_id AS group_id_23, t0.design_group_id AS design_group_id_24 FROM products t0 WHERE t0.id = ? |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.price AS price_2, t0.price_currency AS price_currency_3, t0.inventory_level AS inventory_level_4, t0.weight AS weight_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.product_id AS product_id_8 FROM product_variants t0 WHERE t0.product_id = ? |
DEBUG
10:19:34
|
doctrine
|
SELECT t1.id AS id_2, t1.name AS name_3, t1.description AS description_4, t1.activated_at AS activated_at_5, t1.deactivated_at AS deactivated_at_6, t1.created_at AS created_at_7, t1.updated_at AS updated_at_8, t0.discount_amount AS discount_amount_9, t0.discount_rate AS discount_rate_10, t0.currency AS currency_11, t0.product_id AS product_id_12, t1.entity_type FROM product_promotions t0 INNER JOIN promotion t1 ON t0.id = t1.id WHERE t0.product_id = ? ORDER BY t1.activated_at DESC |
DEBUG
10:19:34
|
doctrine
|
SELECT t1.id AS id_2, t1.name AS name_3, t1.description AS description_4, t1.activated_at AS activated_at_5, t1.deactivated_at AS deactivated_at_6, t1.created_at AS created_at_7, t1.updated_at AS updated_at_8, t0.discount_amount AS discount_amount_9, t0.discount_rate AS discount_rate_10, t0.currency AS currency_11, t0.product_id AS product_id_12, t1.entity_type FROM product_promotions t0 INNER JOIN promotion t1 ON t0.id = t1.id WHERE t0.product_id = ? ORDER BY t1.activated_at DESC |
DEBUG
10:19:34
|
doctrine
|
SELECT p0_.id AS id_0, p0_.min_quantity AS min_quantity_1, p0_.price AS price_2, p0_.price_currency AS price_currency_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.group_id AS group_id_6, p0_.parent_id AS parent_id_7 FROM pricing_rules p0_ WHERE p0_.min_quantity <= ? AND p0_.group_id = ? AND p0_.parent_id IS NULL AND p0_.id NOT IN (SELECT DISTINCT p1_.id FROM pricing_rules p1_ INNER JOIN pricing_rules p2_ ON p1_.id = p2_.parent_id) ORDER BY p0_.min_quantity DESC LIMIT 1 |
DEBUG
10:19:34
|
doctrine
|
SELECT p0_.id AS id_0, p0_.min_quantity AS min_quantity_1, p0_.price AS price_2, p0_.price_currency AS price_currency_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.group_id AS group_id_6, p0_.parent_id AS parent_id_7 FROM pricing_rules p0_ WHERE p0_.min_quantity <= ? AND p0_.group_id = ? AND p0_.parent_id IS NULL AND p0_.id NOT IN (SELECT DISTINCT p1_.id FROM pricing_rules p1_ INNER JOIN pricing_rules p2_ ON p1_.id = p2_.parent_id) ORDER BY p0_.min_quantity DESC LIMIT 1 |
DEBUG
10:19:34
|
doctrine
|
SELECT DISTINCT p0_.id AS id_0, p0_.min_quantity AS min_quantity_1, p0_.price AS price_2, p0_.price_currency AS price_currency_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.group_id AS group_id_6, p0_.parent_id AS parent_id_7 FROM pricing_rules p0_ LEFT JOIN pricing_rules p1_ ON p0_.id = p1_.parent_id WHERE p0_.parent_id IS NULL AND p0_.group_id = 1 AND p0_.min_quantity <= 1 AND (p1_.group_id = 22 AND p1_.min_quantity <= 1) |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.min_quantity AS min_quantity_2, t0.price AS price_3, t0.price_currency AS price_currency_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.group_id AS group_id_7, t0.parent_id AS parent_id_8 FROM pricing_rules t0 WHERE t0.parent_id = ? ORDER BY t0.id ASC |
DEBUG
10:19:34
|
doctrine
|
SELECT DISTINCT p0_.id AS id_0, p0_.min_quantity AS min_quantity_1, p0_.price AS price_2, p0_.price_currency AS price_currency_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.group_id AS group_id_6, p0_.parent_id AS parent_id_7 FROM pricing_rules p0_ LEFT JOIN pricing_rules p1_ ON p0_.id = p1_.parent_id WHERE p0_.parent_id IS NULL AND p0_.group_id = 22 AND p0_.min_quantity <= 1 AND (p1_.group_id = 1 AND p1_.min_quantity <= 1) |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.type AS type_2, t0.sequence_no AS sequence_no_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.bundle_id AS bundle_id_6, t0.product_id AS product_id_7, t0.product_group_id AS product_group_id_8, t0.group_default_product_id AS group_default_product_id_9 FROM product_bundle_items t0 WHERE t0.bundle_id = ? ORDER BY t0.sequence_no ASC |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.name AS name_3, t0.description AS description_4, t0.price AS price_5, t0.compare_at_price AS compare_at_price_6, t0.price_currency AS price_currency_7, t0.inventory_level AS inventory_level_8, t0.weight AS weight_9, t0.activated_at AS activated_at_10, t0.deactivated_at AS deactivated_at_11, t0.back_order_enabled AS back_order_enabled_12, t0.back_order_alert AS back_order_alert_13, t0.hide_product AS hide_product_14, t0.design_label AS design_label_15, t0.product_type AS product_type_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.slug AS slug_19, t0.primary_image_id AS primary_image_id_20, t0.size_guide_image_id AS size_guide_image_id_21, t0.design_thumbnail_id AS design_thumbnail_id_22, t0.group_id AS group_id_23, t0.design_group_id AS design_group_id_24 FROM products t0 WHERE t0.id = ? |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.price AS price_2, t0.price_currency AS price_currency_3, t0.inventory_level AS inventory_level_4, t0.weight AS weight_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.product_id AS product_id_8 FROM product_variants t0 WHERE t0.product_id = ? |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.name AS name_3, t0.description AS description_4, t0.price AS price_5, t0.compare_at_price AS compare_at_price_6, t0.price_currency AS price_currency_7, t0.inventory_level AS inventory_level_8, t0.weight AS weight_9, t0.activated_at AS activated_at_10, t0.deactivated_at AS deactivated_at_11, t0.back_order_enabled AS back_order_enabled_12, t0.back_order_alert AS back_order_alert_13, t0.hide_product AS hide_product_14, t0.design_label AS design_label_15, t0.product_type AS product_type_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.slug AS slug_19, t0.primary_image_id AS primary_image_id_20, t0.size_guide_image_id AS size_guide_image_id_21, t0.design_thumbnail_id AS design_thumbnail_id_22, t0.group_id AS group_id_23, t0.design_group_id AS design_group_id_24 FROM products t0 WHERE t0.id = ? |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.price AS price_2, t0.price_currency AS price_currency_3, t0.inventory_level AS inventory_level_4, t0.weight AS weight_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.product_id AS product_id_8 FROM product_variants t0 WHERE t0.product_id = ? |
DEBUG
10:19:34
|
doctrine
|
SELECT t1.id AS id_2, t1.name AS name_3, t1.description AS description_4, t1.activated_at AS activated_at_5, t1.deactivated_at AS deactivated_at_6, t1.created_at AS created_at_7, t1.updated_at AS updated_at_8, t0.discount_amount AS discount_amount_9, t0.discount_rate AS discount_rate_10, t0.currency AS currency_11, t0.product_id AS product_id_12, t1.entity_type FROM product_promotions t0 INNER JOIN promotion t1 ON t0.id = t1.id WHERE t0.product_id = ? ORDER BY t1.activated_at DESC |
DEBUG
10:19:34
|
doctrine
|
SELECT t1.id AS id_2, t1.name AS name_3, t1.description AS description_4, t1.activated_at AS activated_at_5, t1.deactivated_at AS deactivated_at_6, t1.created_at AS created_at_7, t1.updated_at AS updated_at_8, t0.discount_amount AS discount_amount_9, t0.discount_rate AS discount_rate_10, t0.currency AS currency_11, t0.product_id AS product_id_12, t1.entity_type FROM product_promotions t0 INNER JOIN promotion t1 ON t0.id = t1.id WHERE t0.product_id = ? ORDER BY t1.activated_at DESC |
DEBUG
10:19:34
|
doctrine
|
SELECT p0_.id AS id_0, p0_.min_quantity AS min_quantity_1, p0_.price AS price_2, p0_.price_currency AS price_currency_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.group_id AS group_id_6, p0_.parent_id AS parent_id_7 FROM pricing_rules p0_ WHERE p0_.min_quantity <= ? AND p0_.group_id = ? AND p0_.parent_id IS NULL AND p0_.id NOT IN (SELECT DISTINCT p1_.id FROM pricing_rules p1_ INNER JOIN pricing_rules p2_ ON p1_.id = p2_.parent_id) ORDER BY p0_.min_quantity DESC LIMIT 1 |
DEBUG
10:19:34
|
doctrine
|
SELECT p0_.id AS id_0, p0_.min_quantity AS min_quantity_1, p0_.price AS price_2, p0_.price_currency AS price_currency_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.group_id AS group_id_6, p0_.parent_id AS parent_id_7 FROM pricing_rules p0_ WHERE p0_.min_quantity <= ? AND p0_.group_id = ? AND p0_.parent_id IS NULL AND p0_.id NOT IN (SELECT DISTINCT p1_.id FROM pricing_rules p1_ INNER JOIN pricing_rules p2_ ON p1_.id = p2_.parent_id) ORDER BY p0_.min_quantity DESC LIMIT 1 |
DEBUG
10:19:34
|
doctrine
|
SELECT DISTINCT p0_.id AS id_0, p0_.min_quantity AS min_quantity_1, p0_.price AS price_2, p0_.price_currency AS price_currency_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.group_id AS group_id_6, p0_.parent_id AS parent_id_7 FROM pricing_rules p0_ LEFT JOIN pricing_rules p1_ ON p0_.id = p1_.parent_id WHERE p0_.parent_id IS NULL AND p0_.group_id = 1 AND p0_.min_quantity <= 1 AND (p1_.group_id = 12 AND p1_.min_quantity <= 1) |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.min_quantity AS min_quantity_2, t0.price AS price_3, t0.price_currency AS price_currency_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.group_id AS group_id_7, t0.parent_id AS parent_id_8 FROM pricing_rules t0 WHERE t0.parent_id = ? ORDER BY t0.id ASC |
DEBUG
10:19:34
|
doctrine
|
SELECT DISTINCT p0_.id AS id_0, p0_.min_quantity AS min_quantity_1, p0_.price AS price_2, p0_.price_currency AS price_currency_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.group_id AS group_id_6, p0_.parent_id AS parent_id_7 FROM pricing_rules p0_ LEFT JOIN pricing_rules p1_ ON p0_.id = p1_.parent_id WHERE p0_.parent_id IS NULL AND p0_.group_id = 12 AND p0_.min_quantity <= 1 AND (p1_.group_id = 1 AND p1_.min_quantity <= 1) |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.type AS type_2, t0.sequence_no AS sequence_no_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.bundle_id AS bundle_id_6, t0.product_id AS product_id_7, t0.product_group_id AS product_group_id_8, t0.group_default_product_id AS group_default_product_id_9 FROM product_bundle_items t0 WHERE t0.bundle_id = ? ORDER BY t0.sequence_no ASC |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.name AS name_3, t0.description AS description_4, t0.price AS price_5, t0.compare_at_price AS compare_at_price_6, t0.price_currency AS price_currency_7, t0.inventory_level AS inventory_level_8, t0.weight AS weight_9, t0.activated_at AS activated_at_10, t0.deactivated_at AS deactivated_at_11, t0.back_order_enabled AS back_order_enabled_12, t0.back_order_alert AS back_order_alert_13, t0.hide_product AS hide_product_14, t0.design_label AS design_label_15, t0.product_type AS product_type_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.slug AS slug_19, t0.primary_image_id AS primary_image_id_20, t0.size_guide_image_id AS size_guide_image_id_21, t0.design_thumbnail_id AS design_thumbnail_id_22, t0.group_id AS group_id_23, t0.design_group_id AS design_group_id_24 FROM products t0 WHERE t0.id = ? |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.price AS price_2, t0.price_currency AS price_currency_3, t0.inventory_level AS inventory_level_4, t0.weight AS weight_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.product_id AS product_id_8 FROM product_variants t0 WHERE t0.product_id = ? |
DEBUG
10:19:34
|
doctrine
|
SELECT t1.id AS id_2, t1.name AS name_3, t1.description AS description_4, t1.activated_at AS activated_at_5, t1.deactivated_at AS deactivated_at_6, t1.created_at AS created_at_7, t1.updated_at AS updated_at_8, t0.discount_amount AS discount_amount_9, t0.discount_rate AS discount_rate_10, t0.currency AS currency_11, t0.product_id AS product_id_12, t1.entity_type FROM product_promotions t0 INNER JOIN promotion t1 ON t0.id = t1.id WHERE t0.product_id = ? ORDER BY t1.activated_at DESC |
DEBUG
10:19:34
|
doctrine
|
SELECT p0_.id AS id_0, p0_.min_quantity AS min_quantity_1, p0_.price AS price_2, p0_.price_currency AS price_currency_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.group_id AS group_id_6, p0_.parent_id AS parent_id_7 FROM pricing_rules p0_ WHERE p0_.min_quantity <= ? AND p0_.group_id = ? AND p0_.parent_id IS NULL AND p0_.id NOT IN (SELECT DISTINCT p1_.id FROM pricing_rules p1_ INNER JOIN pricing_rules p2_ ON p1_.id = p2_.parent_id) ORDER BY p0_.min_quantity DESC LIMIT 1 |
DEBUG
10:19:34
|
doctrine
|
SELECT p0_.id AS id_0, p0_.min_quantity AS min_quantity_1, p0_.price AS price_2, p0_.price_currency AS price_currency_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.group_id AS group_id_6, p0_.parent_id AS parent_id_7 FROM pricing_rules p0_ WHERE p0_.min_quantity <= ? AND p0_.group_id = ? AND p0_.parent_id IS NULL AND p0_.id NOT IN (SELECT DISTINCT p1_.id FROM pricing_rules p1_ INNER JOIN pricing_rules p2_ ON p1_.id = p2_.parent_id) ORDER BY p0_.min_quantity DESC LIMIT 1 |
DEBUG
10:19:34
|
doctrine
|
SELECT DISTINCT p0_.id AS id_0, p0_.min_quantity AS min_quantity_1, p0_.price AS price_2, p0_.price_currency AS price_currency_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.group_id AS group_id_6, p0_.parent_id AS parent_id_7 FROM pricing_rules p0_ LEFT JOIN pricing_rules p1_ ON p0_.id = p1_.parent_id WHERE p0_.parent_id IS NULL AND p0_.group_id = 1 AND p0_.min_quantity <= 1 AND (p1_.group_id = 2 AND p1_.min_quantity <= 1) |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.min_quantity AS min_quantity_2, t0.price AS price_3, t0.price_currency AS price_currency_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.group_id AS group_id_7, t0.parent_id AS parent_id_8 FROM pricing_rules t0 WHERE t0.parent_id = ? ORDER BY t0.id ASC |
DEBUG
10:19:34
|
doctrine
|
SELECT DISTINCT p0_.id AS id_0, p0_.min_quantity AS min_quantity_1, p0_.price AS price_2, p0_.price_currency AS price_currency_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.group_id AS group_id_6, p0_.parent_id AS parent_id_7 FROM pricing_rules p0_ LEFT JOIN pricing_rules p1_ ON p0_.id = p1_.parent_id WHERE p0_.parent_id IS NULL AND p0_.group_id = 2 AND p0_.min_quantity <= 1 AND (p1_.group_id = 1 AND p1_.min_quantity <= 1) |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.type AS type_2, t0.sequence_no AS sequence_no_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.bundle_id AS bundle_id_6, t0.product_id AS product_id_7, t0.product_group_id AS product_group_id_8, t0.group_default_product_id AS group_default_product_id_9 FROM product_bundle_items t0 WHERE t0.bundle_id = ? ORDER BY t0.sequence_no ASC |
DEBUG
10:19:34
|
doctrine
|
SELECT p0_.id AS id_0, p0_.min_quantity AS min_quantity_1, p0_.price AS price_2, p0_.price_currency AS price_currency_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.group_id AS group_id_6, p0_.parent_id AS parent_id_7 FROM pricing_rules p0_ WHERE p0_.min_quantity <= ? AND p0_.group_id = ? AND p0_.parent_id IS NULL AND p0_.id NOT IN (SELECT DISTINCT p1_.id FROM pricing_rules p1_ INNER JOIN pricing_rules p2_ ON p1_.id = p2_.parent_id) ORDER BY p0_.min_quantity DESC LIMIT 1 |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.path AS path_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.hover_image_id AS hover_image_id_5, t0.product_id AS product_id_6 FROM product_primary_images t0 WHERE t0.id = ? |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.sequence_no AS sequence_no_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.product_id AS product_id_6 FROM product_feature_images t0 WHERE t0.product_id = ? ORDER BY t0.sequence_no ASC |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.sequence_no AS sequence_no_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.product_id AS product_id_6 FROM product_mobile_feature_images t0 WHERE t0.product_id = ? ORDER BY t0.sequence_no ASC |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.path AS path_2, t0.sequence_no AS sequence_no_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.product_id AS product_id_6 FROM product_images t0 WHERE t0.product_id = ? ORDER BY t0.sequence_no ASC |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.path AS path_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5 FROM product_size_guide_images t0 WHERE t0.id = ? |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.main_category_id AS main_category_id_5 FROM product_groups t0 WHERE t0.id = ? |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.slug AS slug_6, t0.attribute_id AS attribute_id_7 FROM attribute_values t0 INNER JOIN product_variants_attribute_values ON t0.id = product_variants_attribute_values.attribute_value_id WHERE product_variants_attribute_values.product_variant_id = ? |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.slug AS slug_5 FROM attributes t0 WHERE t0.id = ? |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.slug AS slug_6, t0.attribute_id AS attribute_id_7 FROM attribute_values t0 INNER JOIN product_variants_attribute_values ON t0.id = product_variants_attribute_values.attribute_value_id WHERE product_variants_attribute_values.product_variant_id = ? |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.slug AS slug_6, t0.attribute_id AS attribute_id_7 FROM attribute_values t0 INNER JOIN product_variants_attribute_values ON t0.id = product_variants_attribute_values.attribute_value_id WHERE product_variants_attribute_values.product_variant_id = ? |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.slug AS slug_6, t0.attribute_id AS attribute_id_7 FROM attribute_values t0 INNER JOIN product_variants_attribute_values ON t0.id = product_variants_attribute_values.attribute_value_id WHERE product_variants_attribute_values.product_variant_id = ? |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.slug AS slug_6, t0.attribute_id AS attribute_id_7 FROM attribute_values t0 INNER JOIN product_variants_attribute_values ON t0.id = product_variants_attribute_values.attribute_value_id WHERE product_variants_attribute_values.product_variant_id = ? |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.slug AS slug_6, t0.attribute_id AS attribute_id_7 FROM attribute_values t0 INNER JOIN product_variants_attribute_values ON t0.id = product_variants_attribute_values.attribute_value_id WHERE product_variants_attribute_values.product_variant_id = ? |
DEBUG
10:19:34
|
doctrine
|
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.slug AS slug_6, t0.attribute_id AS attribute_id_7 FROM attribute_values t0 INNER JOIN product_variants_attribute_values ON t0.id = product_variants_attribute_values.attribute_value_id WHERE product_variants_attribute_values.product_variant_id = ? |
DEBUG
10:19:34
|
event
|
Notified event "kernel.view" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelView". |
CRITICAL
10:19:34
|
request
|
Uncaught PHP Exception Twig\Error\RuntimeError: "Variable "tagtoo_advertiser_id" does not exist." at /var/www/panaz/src/AppBundle/Resources/views/web/base.html.twig line 34 |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "Http\HttplugBundle\Discovery\ConfiguredClientsStrategy::onEvent". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "Http\HttplugBundle\Collector\PluginClientFactoryListener::onEvent". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\FragmentListener::onKernelRequest". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\ResolveControllerNameSubscriber::onKernelRequest". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "FOS\RestBundle\EventListener\BodyListener::onKernelRequest". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelRequest". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.request" to listener "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelController". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelController". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RequestDataCollector::onKernelController". |
DEBUG
10:19:34
|
event
|
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController". |