GET https://africafirst.graph-life.fr/cart/json

Query Metrics

10 Database Queries
3 Different statements
3.74 ms Query time
1 Invalid entities
5 Managed entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

#▲ Time Info
1 0.45 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "paymentMethods_key"
]
2 0.44 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "currency"
]
3 0.32 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "shippingDelay"
]
4 0.27 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "takeAway"
]
5 0.38 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "activeShippment"
]
6 0.55 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "currency"
]
7 0.27 ms
SELECT pt.id, pt.name, pt.data, pt.type,
               CASE WHEN pt.type = 'PromotionProduct' THEN 999 ELSE 1 END AS priority,
               pt.date_end AS dateEnd
        FROM promotion pt
        WHERE pt.date_end > ?
Parameters:
[
  "2026-11-17"
]
8 0.37 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.data AS data_2, p0_.type AS type_3, CASE WHEN p0_.type = 'PromotionProduct' THEN 999 ELSE 1 END AS sclr_4, p0_.date_end AS date_end_5 FROM promotion p0_ WHERE (p0_.type = 'PromotionProductType' AND p0_.date_end >= ?) OR (p0_.type = 'PromotionProductGroup' AND p0_.date_end >= ?) OR (p0_.type = 'PromotionCategory' AND p0_.date_end >= ?)
Parameters:
[
  "2026-11-17 13:57:25"
  "2026-11-17 13:57:25"
  "2026-11-17 13:57:25"
]
9 0.36 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "takeAway"
]
10 0.32 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "shippingDelay"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

0 Hits
0 Misses
0 Puts

Managed Entities

default entity manager

Class Amount of managed objects
Graphlife\CMSBundle\Entity\Parameter 5

Entities Mapping

Class Mapping errors
Graphlife\LMSBundle\Entity\Document No errors.
Graphlife\LMSBundle\Entity\Event No errors.
Graphlife\LMSBundle\Entity\Formation No errors.
Graphlife\LMSBundle\Entity\Lesson No errors.
Graphlife\LMSBundle\Entity\LessonStatus No errors.
Graphlife\LMSBundle\Entity\LiveSession No errors.
Graphlife\LMSBundle\Entity\Question No errors.
Graphlife\LMSBundle\Entity\QuestionFAQ No errors.
Graphlife\LMSBundle\Entity\QuestionFAQCategory No errors.
Graphlife\LMSBundle\Entity\StudentClass No errors.
Graphlife\LMSBundle\Entity\Test No errors.
Graphlife\LMSBundle\Entity\UserCourse No errors.
Graphlife\LMSBundle\Entity\VideoProgress No errors.
Graphlife\LMSBundle\Entity\VideoUploading No errors.
Graphlife\CMSPaymentBundle\Entity\Currency No errors.
Graphlife\CMSPaymentBundle\Entity\Product No errors.
Graphlife\CMSPaymentBundle\Entity\Package No errors.
Graphlife\CMSPaymentBundle\Entity\PaymentMethod No errors.
Graphlife\CMSPaymentBundle\Entity\PaymentPlan No errors.
Graphlife\CMSPaymentBundle\Entity\ProductImage No errors.
Graphlife\CMSPaymentBundle\Entity\ProductTax No errors.
Graphlife\CMSPaymentBundle\Entity\Promotion No errors.
Graphlife\CMSPaymentBundle\Entity\ShippmentStatus No errors.
Graphlife\CMSPaymentBundle\Entity\Stock No errors.
Graphlife\CMSPaymentBundle\Entity\Transporter No errors.
Graphlife\CMSPaymentBundle\Entity\Category No errors.
Graphlife\CMSPaymentBundle\Entity\CodePromo No errors.
Graphlife\CMSPaymentBundle\Entity\PaymentStatus No errors.
Graphlife\CMSPaymentBundle\Entity\ShippingMethod No errors.
Graphlife\CMSPaymentBundle\Entity\Shippment No errors.
Graphlife\CMSPaymentBundle\Entity\Transaction
  • The association Graphlife\CMSPaymentBundle\Entity\Transaction#status refers to the inverse side Graphlife\CMSPaymentBundle\Entity\PaymentStatus#payments which targets a different entity (Graphlife\CMSPaymentBundle\Entity\Payment).
Graphlife\CMSPaymentBundle\Entity\Payment No errors.
Graphlife\CMSPaymentBundle\Entity\PaymentMethodCountryConfiguration No errors.
Graphlife\CMSPaymentBundle\Entity\ProductType No errors.
Graphlife\CMSBundle\Entity\Country No errors.
Graphlife\CMSBundle\Entity\NewsletterEmail No errors.
Graphlife\CMSBundle\Entity\ParameterCategory No errors.
Graphlife\CMSBundle\Entity\Widget No errors.
Graphlife\CMSBundle\Entity\EntityTranslation No errors.
Graphlife\CMSBundle\Entity\Language No errors.
Graphlife\CMSBundle\Entity\Menu No errors.
Graphlife\CMSBundle\Entity\Parameter No errors.
Graphlife\CMSBundle\Entity\PolicyTerm No errors.
Graphlife\CMSBundle\Entity\PostCategory No errors.
Graphlife\CMSBundle\Entity\User No errors.
Graphlife\CMSBundle\Entity\Page No errors.
Graphlife\CMSBundle\Entity\Post No errors.
Graphlife\CMSBundle\Entity\Banner No errors.
Graphlife\CMSBundle\Entity\Email No errors.
Graphlife\CMSBundle\Entity\Notification No errors.
App\Entity\BankTransfer No errors.
App\Entity\CommissionFormateur No errors.
App\Entity\CompanyCourse No errors.
App\Entity\DemandeFormateur No errors.
App\Entity\UserCompany No errors.
App\Entity\Company No errors.
App\Entity\CompanyCourseAssignment No errors.
App\Entity\ServiceCompany No errors.
App\Entity\FeatureTour No errors.
App\Entity\FeatureTourProgress No errors.
App\Entity\FeatureTourStep No errors.