Query Metrics
7
Database Queries
7
Different statements
160.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.41 ms (79.47%) |
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 389264 392754 397916 400143 400181 400185 400191 407111 407379 410806 414946 416408 416857 418958 421945 422235 422254 422338 428102 428136 428514 428898 429586 430433 430486 435676 437314 439560 439568 439633 439638 439643 439660 439671 443184 443702 443801 443935 446549 448674 454202 454271 454423 460197 460601 460745 460751 462466 464438 464649 465312 466145 466180 466812 467294 470207 473248 474097 474781 474787 474788 475898 476250 476269 476271 476275 479059 479114 481925 482248 483449 484775 485460 486915 486958 488439 490412 490929 491988 495007 498491 502305 503961 505822 505826 506044 506055 506824 509479 512212 512895 513728 514441 517011 518834 519929 519936 520021 520916 523907 524637 528198 531685 531996 532689 534228 547607 549848 550219 561456 562985 563151 563443 563447 564173 592951 610087 665518 682181 730352 ] |
||||||||||||||||||||||||||||||
|
21.33 ms (13.30%) |
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 428898 439568 439660 443184 443702 443801 448674 460601 474781 474788 414946 418958 422235 430433 430486 435676 466145 506055 528198 486958 514441 520021 485460 495007 512895 490929 506824 520916 400185 428514 410806 428102 407111 416857 439671 443935 464438 466812 467294 474097 454423 464649 505826 531996 502305 505822 532689 534228 512212 531685 460197 476250 484775 562985 563151 563447 547607 550219 564173 665518 682181 549848 561456 563443 592951 610087 730352 400191 407379 428136 437314 439643 460745 462466 466180 470207 473248 476269 476275 479059 400143 460751 475898 476271 479114 400181 439560 474787 389264 392754 397916 416408 421945 439633 439638 454271 481925 422254 422338 429586 446549 454202 465312 482248 519929 523907 488439 490412 503961 506044 513728 524637 483449 486915 491988 509479 517011 498491 518834 519936 ] |
||||||||||||||||||||||||||||||
|
3.31 ms (2.06%) |
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 389264 392754 397916 400143 400181 400185 400191 407111 407379 410806 414946 416408 416857 418958 421945 422235 422254 422338 428102 428136 428514 428898 429586 430433 430486 435676 437314 439560 439568 439633 439638 439643 439660 439671 443184 443702 443801 443935 446549 448674 454202 454271 454423 460197 460601 460745 460751 462466 464438 464649 465312 466145 466180 466812 467294 470207 473248 474097 474781 474787 474788 475898 476250 476269 476271 476275 479059 479114 481925 482248 483449 484775 485460 486915 486958 488439 490412 490929 491988 495007 498491 502305 503961 505822 505826 506044 506055 506824 509479 512212 512895 513728 514441 517011 518834 519929 519936 520021 520916 523907 524637 528198 531685 531996 532689 534228 547607 549848 550219 561456 562985 563151 563443 563447 564173 592951 610087 665518 682181 730352 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"son and old"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (1.35%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"son old"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"son old"
]
|
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.