Query Metrics
7
Database Queries
7
Different statements
360.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
334.43 ms (92.73%) |
1 |
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 389729 400181 410806 418958 421822 422168 422254 422338 428136 430486 437497 440631 443167 443935 446132 447828 448955 449897 450319 460197 460659 460751 463624 464413 464438 464649 464890 465312 466762 468091 468884 470207 471883 474777 474781 474786 474787 474791 475174 476269 476271 476280 476628 479114 481925 485057 485172 485460 490929 491988 493166 502305 506044 506131 510518 512212 513722 514301 514441 516226 516281 517011 518159 519480 519735 520694 520695 521520 521759 523907 524109 524284 524486 524637 525152 527181 529157 531996 532012 534228 537020 537123 538010 538970 549739 549825 549848 550219 550221 557551 561456 561607 562985 563151 563432 564173 566928 571976 575704 577051 579848 588755 591296 598999 600965 603055 609203 610087 610587 622667 626266 659986 665492 679709 715786 720258 729635 730352 756209 806084 ] |
||||||||||||||||||||||||||||||
|
17.02 ms (4.72%) |
1 |
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 550221 557551 575704 659986 665492 720258 715786 549739 563432 566928 579848 610587 588755 609203 622667 806084 729635 756209 389729 463624 475174 421822 448955 460659 468091 471883 474791 466762 476280 474781 474786 418958 430486 449897 519480 529157 538970 506131 513722 514441 516281 519735 485460 493166 537020 490929 524486 527181 538010 464890 485057 440631 410806 443167 443935 446132 464438 450319 464649 531996 532012 518159 521759 502305 516226 520695 524284 534228 512212 537123 460197 562985 563151 550219 564173 549825 561607 679709 549848 561456 571976 577051 610087 600965 626266 591296 603055 598999 730352 422168 428136 447828 470207 474777 476269 476628 460751 476271 479114 400181 437497 474787 481925 422254 422338 464413 465312 468884 521520 523907 525152 506044 510518 524637 491988 517011 520694 524109 485172 514301 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (0.82%) |
1 |
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 389729 400181 410806 418958 421822 422168 422254 422338 428136 430486 437497 440631 443167 443935 446132 447828 448955 449897 450319 460197 460659 460751 463624 464413 464438 464649 464890 465312 466762 468091 468884 470207 471883 474777 474781 474786 474787 474791 475174 476269 476271 476280 476628 479114 481925 485057 485172 485460 490929 491988 493166 502305 506044 506131 510518 512212 513722 514301 514441 516226 516281 517011 518159 519480 519735 520694 520695 521520 521759 523907 524109 524284 524486 524637 525152 527181 529157 531996 532012 534228 537020 537123 538010 538970 549739 549825 549848 550219 550221 557551 561456 561607 562985 563151 563432 564173 566928 571976 575704 577051 579848 588755 591296 598999 600965 603055 609203 610087 610587 622667 626266 659986 665492 679709 715786 720258 729635 730352 756209 806084 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom cock son"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom cock son"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom cock son"
]
|
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.