Query Metrics
7
Database Queries
7
Different statements
6.06 ms
Query time
2
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.82 ms |
SELECT o0_.id AS id_0, o0_.o_link AS o_link_1, o0_.o_url AS o_url_2, o0_.o_title AS o_title_3, o0_.o_sub_title AS o_sub_title_4, o0_.o_create_time AS o_create_time_5, o0_.o_delete_time AS o_delete_time_6, o0_.o_public_flag AS o_public_flag_7 FROM o_index_head_image o0_ WHERE o0_.o_delete_time IS NULL AND o0_.o_public_flag = 1 ORDER BY o0_.id ASC
Parameters:
[] |
2 | 0.79 ms |
SELECT o0_.id AS id_0, o0_.o_name AS o_name_1, o0_.o_en_name AS o_en_name_2, o0_.o_image_url AS o_image_url_3, o0_.o_public_time AS o_public_time_4, o0_.o_create_time AS o_create_time_5, o0_.o_delete_time AS o_delete_time_6 FROM o_index_highlight o0_ WHERE o0_.o_delete_time IS NULL AND o0_.o_public_time IS NOT NULL ORDER BY o0_.id ASC
Parameters:
[] |
3 | 0.90 ms |
SELECT o0_.id AS id_0, o0_.o_name AS o_name_1, o0_.o_en_name AS o_en_name_2, o0_.o_sort_name AS o_sort_name_3, o0_.o_styleNo AS o_styleNo_4, o0_.o_star AS o_star_5, o0_.o_public_time AS o_public_time_6, o0_.o_tag AS o_tag_7, o0_.o_create_time AS o_create_time_8, o0_.o_delete_time AS o_delete_time_9, o0_.o_index_time AS o_index_time_10, o0_.o_intro AS o_intro_11, o0_.o_price AS o_price_12, o0_.o_size AS o_size_13, o0_.o_color AS o_color_14, o0_.o_season AS o_season_15, o0_.o_level AS o_level_16, o0_.o_model AS o_model_17, o0_.o_is_buy AS o_is_buy_18 FROM o_goods o0_ WHERE o0_.o_public_time IS NOT NULL LIMIT 16
Parameters:
[] |
4 | 1.13 ms |
SELECT t0.id AS id_1, t0.o_delete_time AS o_delete_time_2, t0.o_index_highlight_id AS o_index_highlight_id_3, t0.o_goods_id AS o_goods_id_4 FROM o_index_highlight_goods t0 WHERE t0.o_index_highlight_id = ?
Parameters:
[
1
]
|
5 | 0.82 ms |
SELECT t0.id AS id_1, t0.o_name AS o_name_2, t0.o_en_name AS o_en_name_3, t0.o_sort_name AS o_sort_name_4, t0.o_styleNo AS o_styleNo_5, t0.o_star AS o_star_6, t0.o_public_time AS o_public_time_7, t0.o_tag AS o_tag_8, t0.o_create_time AS o_create_time_9, t0.o_delete_time AS o_delete_time_10, t0.o_index_time AS o_index_time_11, t0.o_intro AS o_intro_12, t0.o_price AS o_price_13, t0.o_size AS o_size_14, t0.o_color AS o_color_15, t0.o_season AS o_season_16, t0.o_level AS o_level_17, t0.o_model AS o_model_18, t0.o_is_buy AS o_is_buy_19 FROM o_goods t0 WHERE t0.id = ?
Parameters:
[
220
]
|
6 | 0.83 ms |
SELECT t0.id AS id_1, t0.o_url AS o_url_2, t0.o_hex AS o_hex_3, t0.o_hexs AS o_hexs_4, t0.o_color_id AS o_color_id_5, t0.o_goods_id AS o_goods_id_6 FROM o_goods_image t0 WHERE t0.o_goods_id = ?
Parameters:
[
220
]
|
7 | 0.78 ms |
SELECT t0.id AS id_1, t0.o_create_time AS o_create_time_2, t0.o_price AS o_price_3, t0.o_original_price AS o_original_price_4, t0.o_size_id AS o_size_id_5, t0.o_goods_image_id AS o_goods_image_id_6 FROM o_goods_size t0 WHERE t0.o_goods_image_id = ?
Parameters:
[
2162
]
|
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\OIndexHeadImage | No errors. |
App\Entity\OIndexHighlight |
|
App\Entity\OIndexHighlightGoods | No errors. |
App\Entity\OGoods |
|
App\Entity\OCategorySubGoods | No errors. |
App\Entity\OGoodsImage | No errors. |
App\Entity\OGoodsIntro | No errors. |
App\Entity\OColor | No errors. |
App\Entity\OGoodsSize | No errors. |
App\Entity\OSize | No errors. |
App\Entity\OCategorySub | No errors. |