Query Metrics
7
Database Queries
7
Different statements
219.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
193.01 ms (88.08%) |
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 393765 396456 399253 400443 445602 446328 447195 448557 448697 451725 451726 451741 452442 455114 456341 458774 471309 472439 473018 479321 489806 492512 494369 495673 515216 524706 525115 548606 550207 551982 559864 560202 563399 565046 566146 567389 574777 575115 575211 575488 576413 580770 581707 581743 585136 588266 589808 591779 597072 600105 601597 602939 605930 609052 611167 612799 614110 618734 622398 623574 624249 638327 641739 647297 647850 663226 663940 665399 694609 695898 701014 701296 701774 708476 708763 712929 714497 715402 716043 717752 718947 721532 722537 723481 724753 728008 728166 728994 729160 729928 731693 732457 743034 743341 744984 747954 747956 752910 755743 759420 759639 760586 760937 761076 762702 766874 767060 768120 769235 789316 798585 802719 803331 805191 810643 815778 817114 821038 821102 821201 ] |
||||||||||||||||||||||||||||||
|
16.25 ms (7.41%) |
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 701296 712929 717752 722537 567389 600105 589808 591779 601597 789316 802719 803331 743034 769235 805191 724753 731693 747956 760937 761076 762702 728008 728166 728994 752910 767060 729928 732457 759420 768120 729160 744984 760586 618734 798585 560202 716043 622398 602939 548606 551982 566146 647850 647297 714497 563399 574777 623574 759639 605930 400443 448557 451725 451726 451741 456341 447195 448697 479321 446328 452442 495673 515216 559864 701774 580770 588266 624249 755743 766874 638327 458774 471309 393765 455114 399253 473018 489806 524706 492512 494369 472439 612799 396456 815778 817114 821201 821038 821102 525115 663226 663940 694609 723481 665399 715402 718947 721532 695898 708476 611167 614110 641739 597072 609052 743341 747954 701014 708763 810643 550207 585136 445602 565046 575115 575211 575488 576413 581707 581743 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.29%) |
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 393765 396456 399253 400443 445602 446328 447195 448557 448697 451725 451726 451741 452442 455114 456341 458774 471309 472439 473018 479321 489806 492512 494369 495673 515216 524706 525115 548606 550207 551982 559864 560202 563399 565046 566146 567389 574777 575115 575211 575488 576413 580770 581707 581743 585136 588266 589808 591779 597072 600105 601597 602939 605930 609052 611167 612799 614110 618734 622398 623574 624249 638327 641739 647297 647850 663226 663940 665399 694609 695898 701014 701296 701774 708476 708763 712929 714497 715402 716043 717752 718947 721532 722537 723481 724753 728008 728166 728994 729160 729928 731693 732457 743034 743341 744984 747954 747956 752910 755743 759420 759639 760586 760937 761076 762702 766874 767060 768120 769235 789316 798585 802719 803331 805191 810643 815778 817114 821038 821102 821201 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young small cock"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young маленькая cock"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.71%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young маленькая cock"
]
|
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.