Query Metrics
7
Database Queries
7
Different statements
198.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.11 ms (88.69%) |
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 398535 464689 479786 486444 490254 491674 491870 496206 497834 505108 506348 510975 512049 513030 514123 514263 514677 516862 517615 518364 518957 519458 519577 521326 521642 523041 523209 524096 524150 524203 524987 525085 525122 525125 526029 526264 526675 527779 528862 529447 534130 537017 537292 538927 540247 541239 542123 542754 543599 546063 546442 551110 556822 557182 557848 558511 561391 565353 567163 568177 569678 571154 571682 571822 571832 573758 573923 575804 576391 576650 576697 578445 578494 578971 579537 585637 586662 587448 588510 588633 590739 592651 593299 593879 595070 597887 598420 599324 600736 603863 605413 605770 608497 616909 618399 620153 622369 625088 625798 630405 652673 660963 661280 680733 681370 685477 694534 704222 720647 736681 743043 765916 778462 779160 784580 799621 821115 824708 827482 ] |
||||||||||||||||||||||||||||||
|
12.78 ms (6.44%) |
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 608497 514263 541239 497834 526029 514677 565353 593299 599324 605770 524203 579537 523209 529447 595070 600736 576391 597887 784580 743043 567163 464689 521326 527940 542123 571822 685477 557848 561391 573923 578971 603863 585637 592651 622369 625798 680733 524150 588633 514123 525122 588510 519577 527779 506348 523041 578445 576650 652673 546442 618399 491674 543599 537292 528862 518364 576697 505108 571154 661280 513030 521642 526675 542754 571832 571682 525085 534130 512049 517615 575804 569678 558511 660963 616909 625088 491870 540247 546063 630405 821115 799621 720647 779160 765916 519458 524987 524096 556822 573758 605413 490254 590739 578494 496206 537017 557182 598420 479786 568177 551110 586662 587448 704222 398535 736681 778462 526264 525125 694534 620153 593879 824708 827482 538927 518957 510975 681370 486444 516862 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.19%) |
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 398535 464689 479786 486444 490254 491674 491870 496206 497834 505108 506348 510975 512049 513030 514123 514263 514677 516862 517615 518364 518957 519458 519577 521326 521642 523041 523209 524096 524150 524203 524987 525085 525122 525125 526029 526264 526675 527779 528862 529447 534130 537017 537292 538927 540247 541239 542123 542754 543599 546063 546442 551110 556822 557182 557848 558511 561391 565353 567163 568177 569678 571154 571682 571822 571832 573758 573923 575804 576391 576650 576697 578445 578494 578971 579537 585637 586662 587448 588510 588633 590739 592651 593299 593879 595070 597887 598420 599324 600736 603863 605413 605770 608497 616909 618399 620153 622369 625088 625798 630405 652673 660963 661280 680733 681370 685477 694534 704222 720647 736681 743043 765916 778462 779160 784580 799621 821115 824708 827482 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"камшот сиськи"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм сиськ"
]
|
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.