Query Metrics
163
Database Queries
4
Different statements
40.22 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
35.40 ms (88.01%) |
154 |
SELECT t0.id AS id_1, t0.file_title AS file_title_2, t0.file_name AS file_name_3, t0.file_path AS file_path_4, t0.thumb_path AS thumb_path_5, t0.file_extension AS file_extension_6 FROM uploaded_files t0 WHERE t0.id = ?
Parameters:
[
183
]
|
2.85 ms (7.08%) |
1 |
SELECT c0_.id AS id_0, c0_.category_name AS category_name_1, c0_.created_on AS created_on_2, c0_.updated_on AS updated_on_3, c0_.is_active AS is_active_4, c0_.is_inactive_chandigarh AS is_inactive_chandigarh_5, c0_.is_inactive_ludhiana AS is_inactive_ludhiana_6, c0_.is_slides_product AS is_slides_product_7, c0_.sort_order_by AS sort_order_by_8, c0_.in_breakfast AS in_breakfast_9, c0_.in_lunch AS in_lunch_10, c0_.is_dinner AS is_dinner_11, c0_.tweleve_onward AS tweleve_onward_12, c0_.two_onward AS two_onward_13, p1_.id AS id_14, p1_.product_name AS product_name_15, p1_.ingredients AS ingredients_16, p1_.accompaniments AS accompaniments_17, p1_.summary AS summary_18, p1_.price AS price_19, p1_.is_tiffin AS is_tiffin_20, p1_.created_on AS created_on_21, p1_.updated_on AS updated_on_22, p1_.is_active AS is_active_23, p1_.is_inactive_chandigarh AS is_inactive_chandigarh_24, p1_.is_inactive_ludhiana AS is_inactive_ludhiana_25, p1_.offer_price_text_only AS offer_price_text_only_26, p1_.offer_coupon_code AS offer_coupon_code_27, p1_.sort_order_by AS sort_order_by_28, p1_.output_quantity AS output_quantity_29, p1_.output_quantity_measurement AS output_quantity_measurement_30, p1_.per_portion_quantity AS per_portion_quantity_31, p1_.per_portion_measurement AS per_portion_measurement_32, p1_.per_portion_food_cost AS per_portion_food_cost_33, p1_.receipy_written_instruction AS receipy_written_instruction_34, p1_.youtube_video_links AS youtube_video_links_35, p1_.category_id AS category_id_36, p1_.food_type_id AS food_type_id_37, p1_.uploaded_files_id AS uploaded_files_id_38 FROM category c0_ LEFT JOIN product p1_ ON c0_.id = p1_.category_id WHERE p1_.is_tiffin = ? AND p1_.is_active = ? AND c0_.is_active = ? AND (c0_.is_inactive_ludhiana < 1 OR c0_.is_inactive_ludhiana IS NULL) AND (p1_.is_inactive_ludhiana < 1 OR c0_.is_inactive_ludhiana IS NULL) ORDER BY c0_.sort_order_by ASC, p1_.sort_order_by ASC
Parameters:
[ 0 1 1 ] |
1.56 ms (3.88%) |
7 |
SELECT t0.id AS id_1, t0.food_type_name AS food_type_name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4 FROM food_types t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.41 ms (1.03%) |
1 |
SELECT t0.id AS id_1, t0.city_id AS city_id_2, t0.state_id AS state_id_3, t0.postal_code AS postal_code_4, t0.area_name AS area_name_5, t0.description AS description_6 FROM areas t0
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 |
---|---|
FoodAirwayApiBundle\Entity\Areas | No errors. |
FoodAirwayApiBundle\Entity\Category | No errors. |
FoodAirwayApiBundle\Entity\Product | No errors. |
FoodAirwayApiBundle\Entity\FoodTypes | No errors. |
FoodAirwayApiBundle\Entity\UploadedFiles | No errors. |
FoodAirwayApiBundle\Entity\OrderDetail | No errors. |
FoodAirwayApiBundle\Entity\TiffinPlan |
|
FoodAirwayApiBundle\Entity\TiffinNumberOfDays | No errors. |
FoodAirwayApiBundle\Entity\TiffinWeekDays | No errors. |
FoodAirwayApiBundle\Entity\TiffinTimeSlot | No errors. |
FoodAirwayApiBundle\Entity\TiffinOrderDetail |
|
FoodAirwayApiBundle\Entity\AdvertisementBanners | No errors. |