Query Metrics
7
Database Queries
7
Different statements
150.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.75 ms (84.41%) |
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 119687 230986 234832 308582 367800 389660 391099 401593 419891 428121 431494 451458 455227 455519 458462 462466 463208 463759 465672 480707 481684 482788 489995 501205 515757 517553 517723 519480 522678 534634 534710 535379 540533 541798 544831 548001 548499 567496 568375 571770 581040 582444 584247 584400 591111 591121 593445 599681 613769 631183 634766 641487 650606 660356 661906 664467 664602 667974 669874 694551 698111 699573 715403 719897 722063 733368 734084 735891 742333 746092 747048 747076 754312 760898 761315 766781 770167 781842 787626 788031 788121 789243 789474 794618 794952 796888 798755 798959 802916 802927 803251 803438 805923 809890 811099 811456 812110 812114 816092 816709 816817 817338 817387 818621 818836 818919 820010 820117 823893 825425 826429 828030 828220 828221 828260 828315 828341 ] |
||||||||||||||||||||||||||||||
|
12.46 ms (8.30%) |
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 419891 489995 544831 699573 593445 431494 455519 501205 519480 515757 522678 517723 367800 308582 389660 823893 828221 828030 535379 664467 548001 584247 631183 803438 812110 798755 754312 734084 761315 809890 820010 826429 816817 818919 828260 828315 567496 650606 660356 661906 694551 722063 568375 599767 787626 794618 788031 802916 811456 747048 742333 719897 789243 803251 234832 428121 828220 465672 534634 534710 541798 548499 664602 669874 667974 591111 591121 599681 789474 781842 794952 766781 760898 788121 796888 480707 391099 817387 818621 825425 820117 816709 822348 824264 828341 540533 698111 715403 571770 581040 584400 613769 634766 805923 770167 811099 812114 747076 735891 746092 733368 798959 802927 482788 463208 481684 582444 455227 458462 462466 463759 451458 517553 641487 119687 230986 401593 816092 817338 818836 ] |
||||||||||||||||||||||||||||||
|
3.44 ms (2.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 119687 230986 234832 308582 367800 389660 391099 401593 419891 428121 431494 451458 455227 455519 458462 462466 463208 463759 465672 480707 481684 482788 489995 501205 515757 517553 517723 519480 522678 534634 534710 535379 540533 541798 544831 548001 548499 567496 568375 571770 581040 582444 584247 584400 591111 591121 593445 599681 613769 631183 634766 641487 650606 660356 661906 664467 664602 667974 669874 694551 698111 699573 715403 719897 722063 733368 734084 735891 742333 746092 747048 747076 754312 760898 761315 766781 770167 781842 787626 788031 788121 789243 789474 794618 794952 796888 798755 798959 802916 802927 803251 803438 805923 809890 811099 811456 812110 812114 816092 816709 816817 817338 817387 818621 818836 818919 820010 820117 823893 825425 826429 828030 828220 828221 828260 828315 828341 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf in glasses"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf очкастая"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf очкастая"
]
|
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.