Query Metrics
7
Database Queries
7
Different statements
219.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
189.99 ms (86.71%) |
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 307940 405181 414621 417811 419123 419370 469616 491446 498830 501487 516842 518493 519567 523392 529243 530489 530791 530796 531089 531202 531393 532343 532751 532839 533645 533697 533773 536310 536586 536712 537114 537200 537672 537763 537771 537773 538473 541846 545537 556480 561119 565154 576727 582323 582376 583700 585363 590411 596082 599868 599914 599961 599976 600171 600249 600295 600342 600352 601613 604513 604902 610060 612343 614858 617416 617428 620794 625412 625443 629963 631178 632641 634212 634543 634774 636303 637036 637103 639706 639717 640755 642061 643376 644918 644961 646771 646841 646849 648235 648839 648853 648868 650175 650188 650774 650846 651079 651607 656303 666586 666853 668526 668528 668534 668549 676110 676623 676632 677674 678063 678493 679728 679733 708447 716882 720260 720288 760794 788262 792555 ] |
||||||||||||||||||||||||||||||
|
19.48 ms (8.89%) |
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 498830 533697 576727 650175 650846 610060 585363 600295 760794 625443 405181 529243 519567 531393 531089 582323 541846 678493 646771 656303 604513 590411 625412 617428 620794 631178 639717 417811 523392 538473 532839 646849 600249 632641 629963 644961 537763 537771 530489 536586 537200 679728 720260 651079 676110 679733 716882 720288 668528 642061 612343 637103 600352 636303 639706 640755 596082 599868 600342 643376 617416 788262 414621 518493 469616 556480 582376 599961 419123 516842 644918 530791 668534 677674 708447 599914 634212 307940 501487 491446 536712 533773 537114 537773 545537 565154 648235 646841 648853 599976 600171 634543 601613 614858 533645 532751 637036 561119 792555 419370 583700 634774 604902 530796 537672 531202 532343 536310 650774 651607 668549 648839 650188 666853 668526 676632 678063 648868 666586 676623 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.09%) |
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 307940 405181 414621 417811 419123 419370 469616 491446 498830 501487 516842 518493 519567 523392 529243 530489 530791 530796 531089 531202 531393 532343 532751 532839 533645 533697 533773 536310 536586 536712 537114 537200 537672 537763 537771 537773 538473 541846 545537 556480 561119 565154 576727 582323 582376 583700 585363 590411 596082 599868 599914 599961 599976 600171 600249 600295 600342 600352 601613 604513 604902 610060 612343 614858 617416 617428 620794 625412 625443 629963 631178 632641 634212 634543 634774 636303 637036 637103 639706 639717 640755 642061 643376 644918 644961 646771 646841 646849 648235 648839 648853 648868 650175 650188 650774 650846 651079 651607 656303 666586 666853 668526 668528 668534 668549 676110 676623 676632 677674 678063 678493 679728 679733 708447 716882 720260 720288 760794 788262 792555 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc mom anal"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc mom анал"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc mom анал"
]
|
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.