Query Metrics
2
Database Queries
2
Different statements
342.81 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
226.74 ms (66.14%) |
1 |
SELECT p0_.id AS id_0, p0_.item_number AS item_number_1, p0_.carton_number AS carton_number_2, p0_.totalitemvalue AS totalitemvalue_3, p0_.totalctnsvalue AS totalctnsvalue_4, p0_.totalvalue AS totalvalue_5, p0_.box_number AS box_number_6, p0_.bottle_number AS bottle_number_7, p0_.totalboxvalue AS totalboxvalue_8, p0_.sac_number AS sac_number_9, p0_.totalsacvalue AS totalsacvalue_10, p0_.totalbottlevalue AS totalbottlevalue_11, p0_.pricectn AS pricectn_12, p0_.pricesac AS pricesac_13, p0_.pricebtl AS pricebtl_14, p0_.pricebox AS pricebox_15, p0_.priceitem AS priceitem_16, g1_.id AS id_17, g1_.brand AS brand_18, g1_.pricectns AS pricectns_19, g1_.pricebox AS pricebox_20, g1_.pricebottle AS pricebottle_21, g1_.priceitem AS priceitem_22, g1_.pricesac AS pricesac_23, i2_.id AS id_24, i2_.date AS date_25, i2_.label AS label_26, i2_.amount AS amount_27, i2_.latitude AS latitude_28, i2_.longitude AS longitude_29, i2_.cash_amount AS cash_amount_30, i2_.credit_amount AS credit_amount_31, i2_.etat AS etat_32, s3_.id AS id_33, s3_.name AS name_34, s3_.contact AS contact_35, s3_.address AS address_36, s3_.can_sell_cash AS can_sell_cash_37, s3_.is_cashvan AS is_cashvan_38, s4_.id AS id_39, s4_.section AS section_40, s4_.location AS location_41, s4_.shop_name AS shop_name_42, s4_.phone AS phone_43, s4_.credit_limit AS credit_limit_44, s4_.credit_days AS credit_days_45, s4_.name_manager_shop AS name_manager_shop_46, s4_.longitude AS longitude_47, s4_.latitude AS latitude_48, p5_.id AS id_49, p5_.quantity AS quantity_50, p6_.id AS id_51, p6_.required_products_for_free AS required_products_for_free_52, p6_.number_good_free AS number_good_free_53, p6_.unite AS unite_54, p6_.unity_free AS unity_free_55, p6_.date AS date_56, p6_.date_fin AS date_fin_57, p6_.status AS status_58, g7_.id AS id_59, g7_.brand AS brand_60, g7_.pricectns AS pricectns_61, g7_.pricebox AS pricebox_62, g7_.pricebottle AS pricebottle_63, g7_.priceitem AS priceitem_64, g7_.pricesac AS pricesac_65 FROM purchase p0_ LEFT JOIN goods g1_ ON p0_.id_brand_id = g1_.id LEFT JOIN invoice i2_ ON p0_.invoice_id = i2_.id LEFT JOIN sales_men s3_ ON i2_.sales_id = s3_.id LEFT JOIN shop s4_ ON i2_.shop_id = s4_.id LEFT JOIN promotion_invoice p5_ ON i2_.id = p5_.invoice_id AND (p5_.brand_id = g1_.id) LEFT JOIN promotion p6_ ON p5_.promotion_id = p6_.id LEFT JOIN goods g7_ ON p6_.good_id = g7_.id ORDER BY i2_.date DESC LIMIT 400
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
116.07 ms (33.86%) |
1 |
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM purchase p0_ LEFT JOIN goods g1_ ON p0_.id_brand_id = g1_.id LEFT JOIN invoice i2_ ON p0_.invoice_id = i2_.id LEFT JOIN sales_men s3_ ON i2_.sales_id = s3_.id LEFT JOIN shop s4_ ON i2_.shop_id = s4_.id LEFT JOIN promotion_invoice p5_ ON i2_.id = p5_.invoice_id AND (p5_.brand_id = g1_.id) LEFT JOIN promotion p6_ ON p5_.promotion_id = p6_.id LEFT JOIN goods g7_ ON p6_.good_id = g7_.id ORDER BY i2_.date DESC
Parameters:
[]
|
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\Purchase | No errors. |
| App\Entity\Goods | No errors. |
| App\Entity\Invoice | No errors. |
| App\Entity\SalesMen | No errors. |
| App\Entity\Shop | No errors. |
| App\Entity\PromotionInvoice |
|
| App\Entity\Promotion | No errors. |