Query Metrics
7
Database Queries
7
Different statements
146.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.31 ms (82.75%) |
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 387047 398447 406332 413569 421033 423425 425675 426877 432334 435689 448060 449647 451816 454349 457045 460058 462859 463828 466664 469824 475381 477608 478850 484483 489042 493845 500016 502293 506299 506357 507169 512181 513300 516409 518491 519215 519325 520329 523342 523433 524530 525398 525440 532981 534673 536586 537929 545860 548046 553951 554415 555168 556006 557605 557812 559771 564212 568457 568463 569041 570830 570832 574511 577301 582687 582920 585123 586556 587381 588204 595549 596346 597753 598207 599040 599520 601472 601859 603384 604821 609370 613333 620512 620670 621179 622405 625378 625446 626189 626482 633461 637009 637025 652125 660405 666016 666459 669079 676887 677082 686106 693316 695870 701231 706945 707470 724934 729328 740212 740226 747249 758797 760683 780517 785384 796831 807711 808497 809574 815383 ] |
||||||||||||||||||||||||||||||
|
15.41 ms (10.51%) |
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 534673 693316 701231 570832 620670 596346 604821 613333 729328 747249 760683 785384 808497 413569 449647 513300 523433 502293 545860 398447 570830 577301 660405 666016 677082 686106 588204 601472 626189 454349 448060 460058 489042 506357 387047 463828 707470 666459 626482 587381 595549 609370 620512 758797 423425 425675 426877 477608 493845 520329 807711 809574 421033 469824 554415 599040 724934 525440 466664 582687 695870 599520 432334 506299 523342 564212 676887 568463 601859 796831 740226 780517 478850 475381 559771 706945 637025 574511 548046 598207 622405 462859 500016 815383 516409 557605 557812 582920 633461 597753 740212 625446 406332 457045 569041 669079 435689 585123 518491 532981 555168 586556 603384 652125 568457 512181 553951 621179 451816 519215 537929 637009 519325 507169 536586 556006 625378 484483 524530 525398 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.90%) |
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 387047 398447 406332 413569 421033 423425 425675 426877 432334 435689 448060 449647 451816 454349 457045 460058 462859 463828 466664 469824 475381 477608 478850 484483 489042 493845 500016 502293 506299 506357 507169 512181 513300 516409 518491 519215 519325 520329 523342 523433 524530 525398 525440 532981 534673 536586 537929 545860 548046 553951 554415 555168 556006 557605 557812 559771 564212 568457 568463 569041 570830 570832 574511 577301 582687 582920 585123 586556 587381 588204 595549 596346 597753 598207 599040 599520 601472 601859 603384 604821 609370 613333 620512 620670 621179 622405 625378 625446 626189 626482 633461 637009 637025 652125 660405 666016 666459 669079 676887 677082 686106 693316 695870 701231 706945 707470 724934 729328 740212 740226 747249 758797 760683 780517 785384 796831 807711 808497 809574 815383 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girls on top"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк top"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк top"
]
|
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.