Query Metrics
7
Database Queries
7
Different statements
176.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.70 ms (87.70%) |
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 387230 402238 406293 434431 449758 466677 468657 470420 482151 494870 500701 503511 504368 505176 505320 505550 506495 509400 509565 509633 512671 514281 515070 515099 518303 518954 519847 519967 519983 522370 522602 522875 523136 523143 523495 524086 524894 525009 525153 526338 526407 526682 527372 527383 528533 533336 534800 535532 535575 536989 540745 542457 544562 549518 552846 553227 554847 555899 555958 556552 558872 559985 560077 561521 561616 561878 562751 564788 567019 567254 568443 570089 571288 572211 572242 572718 572742 576647 579425 581744 581854 581868 583240 583817 583884 584448 585124 585170 585767 585787 588477 588977 589710 591328 594992 598775 598980 599781 600186 600292 602104 603211 603842 605688 606817 612614 613993 616765 617997 618572 619312 620041 625008 634246 644847 666331 670432 672251 682866 686207 ] |
||||||||||||||||||||||||||||||
|
11.83 ms (6.70%) |
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 555958 558872 562751 571288 581854 583884 559985 560077 570089 581868 544562 572718 572742 584448 666331 670432 672251 564788 567019 567254 576647 598775 599781 588977 591328 618572 620041 585170 600292 603211 617997 619312 402238 434431 523136 585124 505320 540745 572242 589710 518954 524894 542457 561878 549518 561616 588477 644847 505550 503511 528533 526338 572211 581744 583817 568443 579425 553227 554847 686207 682866 552846 555899 556552 561521 583240 585767 585787 600186 594992 598980 603842 605688 612614 616765 606817 625008 602104 613993 634246 387230 406293 466677 468657 449758 470420 482151 509633 519847 522602 527372 533336 535532 536989 500701 515070 518303 519967 522370 522875 523143 526682 505176 506495 509400 509565 512671 514281 515099 525009 525153 526407 534800 494870 504368 519983 523495 524086 527383 535575 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.67%) |
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 387230 402238 406293 434431 449758 466677 468657 470420 482151 494870 500701 503511 504368 505176 505320 505550 506495 509400 509565 509633 512671 514281 515070 515099 518303 518954 519847 519967 519983 522370 522602 522875 523136 523143 523495 524086 524894 525009 525153 526338 526407 526682 527372 527383 528533 533336 534800 535532 535575 536989 540745 542457 544562 549518 552846 553227 554847 555899 555958 556552 558872 559985 560077 561521 561616 561878 562751 564788 567019 567254 568443 570089 571288 572211 572242 572718 572742 576647 579425 581744 581854 581868 583240 583817 583884 584448 585124 585170 585767 585787 588477 588977 589710 591328 594992 598775 598980 599781 600186 600292 602104 603211 603842 605688 606817 612614 613993 616765 617997 618572 619312 620041 625008 634246 644847 666331 670432 672251 682866 686207 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"заглотила сперму"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"заглот сперм"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.82%) |
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.