Query Metrics
7
Database Queries
7
Different statements
120.50 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.41 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.68 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"niksindian sex"
]
|
||||||||||||||||||||||||||||||
| 3 | 11.64 ms |
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id` AND `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id` AND `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 560120 550518 569949 569945 570145 570156 570155 621537 543175 584149 570167 507204 569951 556969 569973 570161 570181 592372 570178 569953 570151 570732 570150 569950 574990 570171 570172 570153 552048 569969 569976 621540 569948 569957 570163 569968 592324 517146 543437 569959 570152 566563 556961 570185 569961 570182 570183 546116 569962 570160 569970 569947 546113 569964 570148 570735 570174 569978 570164 590344 533998 570747 570165 570742 596956 570177 570426 570737 570149 570162 592318 592363 570184 570179 570159 569965 526601 570169 621543 570736 570743 570166 600969 519341 619571 570168 570428 ] |
||||||||||||||||||||||||||||||
| 4 | 2.42 ms |
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 507204 517146 519341 526601 533998 543175 543437 546113 546116 550518 552048 556961 556969 560120 566563 569945 569947 569948 569949 569950 569951 569953 569957 569959 569961 569962 569964 569965 569968 569969 569970 569973 569976 569978 570145 570148 570149 570150 570151 570152 570153 570155 570156 570159 570160 570161 570162 570163 570164 570165 570166 570167 570168 570169 570171 570172 570174 570177 570178 570179 570181 570182 570183 570184 570185 570426 570428 570732 570735 570736 570737 570742 570743 570747 574990 584149 590344 592318 592324 592363 592372 596956 600969 619571 621537 621540 621543 ] |
||||||||||||||||||||||||||||||
| 5 | 100.88 ms |
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id AND f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id` AND `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 507204 517146 519341 526601 533998 543175 543437 546113 546116 550518 552048 556961 556969 560120 566563 569945 569947 569948 569949 569950 569951 569953 569957 569959 569961 569962 569964 569965 569968 569969 569970 569973 569976 569978 570145 570148 570149 570150 570151 570152 570153 570155 570156 570159 570160 570161 570162 570163 570164 570165 570166 570167 570168 570169 570171 570172 570174 570177 570178 570179 570181 570182 570183 570184 570185 570426 570428 570732 570735 570736 570737 570742 570743 570747 574990 584149 590344 592318 592324 592363 592372 596956 600969 619571 621537 621540 621543 ] |
||||||||||||||||||||||||||||||
| 6 | 1.35 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"niksindian секс"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.13 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"niksindian секс"
]
|
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
No loaded entities.