Query Metrics
7
Database Queries
7
Different statements
194.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.50 ms (88.17%) |
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 445472 446929 448402 449970 451758 452547 454113 458449 459163 460560 461255 463490 464042 464800 471858 473154 476432 480474 488510 492753 495737 496361 496686 499326 507360 510994 513589 514147 515268 523374 536906 538077 540428 548410 548537 548571 548572 548581 549081 549367 549815 551321 551894 551898 552234 552584 555186 555587 555591 555785 556393 556872 556884 558607 559910 560940 561020 565537 566970 568600 569740 569761 569769 573036 577581 577775 578528 581649 581659 581969 584291 586583 586861 587951 592874 593080 593385 593514 595511 596911 598440 598462 598834 600157 600402 602533 603616 603753 603814 605601 607735 607742 619394 620569 626482 626551 628362 628710 629673 634049 639139 650818 663374 663441 663482 663968 665226 667290 667543 671585 675541 680460 681027 683424 683955 709428 709688 716543 722280 815483 ] |
||||||||||||||||||||||||||||||
|
13.14 ms (6.75%) |
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 815483 448402 449970 454113 473154 476432 480474 492753 452547 458449 463490 488510 445472 446929 451758 459163 460560 461255 464042 471858 513589 540428 496361 499326 510994 523374 536906 514147 495737 496686 507360 515268 538077 464800 548410 548581 551898 555186 555587 556393 559910 566970 568600 578528 548572 549815 551321 552584 561020 569761 581659 548537 548571 549081 549367 551894 555785 565537 573036 577581 581649 581969 584291 667290 667543 671585 681027 716543 650818 663374 663482 665226 709428 709688 722280 663441 663968 675541 680460 683424 683955 552234 555591 556872 556884 558607 560940 569740 569769 577775 586861 593514 598834 605601 619394 626482 628710 639139 586583 592874 598462 602533 603616 607735 607742 634049 598440 600157 600402 603814 620569 587951 593080 593385 595511 596911 603753 626551 628362 629673 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.32%) |
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 445472 446929 448402 449970 451758 452547 454113 458449 459163 460560 461255 463490 464042 464800 471858 473154 476432 480474 488510 492753 495737 496361 496686 499326 507360 510994 513589 514147 515268 523374 536906 538077 540428 548410 548537 548571 548572 548581 549081 549367 549815 551321 551894 551898 552234 552584 555186 555587 555591 555785 556393 556872 556884 558607 559910 560940 561020 565537 566970 568600 569740 569761 569769 573036 577581 577775 578528 581649 581659 581969 584291 586583 586861 587951 592874 593080 593385 593514 595511 596911 598440 598462 598834 600157 600402 602533 603616 603753 603814 605601 607735 607742 619394 620569 626482 626551 628362 628710 629673 634049 639139 650818 663374 663441 663482 663968 665226 667290 667543 671585 675541 680460 681027 683424 683955 709428 709688 716543 722280 815483 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation man"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мастурбац мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.