Query Metrics
7
Database Queries
7
Different statements
155.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.68 ms (83.47%) |
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 384181 387846 389593 391770 397425 412332 420041 420862 424264 426916 427077 427469 442922 443012 450577 460988 463315 474928 480917 487386 489197 490720 494653 495531 495932 499266 504266 504902 504913 506339 506404 513384 517237 520035 525451 526784 539486 543313 545649 547950 553936 558838 560565 577976 579941 585120 585895 590619 591196 598210 598884 602185 603696 614887 615644 620846 628814 644138 648519 651321 658485 660089 670392 676695 677156 680716 686079 687124 689245 692564 692566 697633 697996 698001 703989 707480 708156 712596 713158 713753 715792 719106 719380 719643 723116 723665 729350 730824 733161 733790 734494 754488 754821 757565 759330 766089 766191 768181 770080 777915 778756 778959 779572 780145 780158 781075 783786 786073 786267 787982 791173 791703 791842 803523 804858 804875 805066 808380 818697 825175 ] |
||||||||||||||||||||||||||||||
|
15.42 ms (9.93%) |
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 547950 712596 778756 780158 804858 779572 781075 791703 783786 759330 766089 770080 733790 754488 766191 723116 777915 780145 786267 384181 480917 460988 489197 490720 520035 513384 474928 397425 670392 450577 558838 517237 603696 506404 494653 658485 698001 708156 786073 729350 787982 730824 734494 768181 713753 719106 778959 791173 424264 387846 463315 539486 680716 391770 686079 420862 648519 526784 805066 692564 545649 577976 499266 504266 579941 715792 442922 506339 677156 687124 676695 713158 689245 697996 644138 598210 602185 628814 389593 495531 543313 692566 697633 504902 723665 553936 804875 757565 754821 791842 525451 615644 719380 620846 707480 443012 495932 412332 660089 651321 560565 590619 585895 614887 504913 426916 591196 598884 818697 703989 585120 825175 719643 803523 733161 808380 427077 487386 420041 427469 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.70%) |
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 384181 387846 389593 391770 397425 412332 420041 420862 424264 426916 427077 427469 442922 443012 450577 460988 463315 474928 480917 487386 489197 490720 494653 495531 495932 499266 504266 504902 504913 506339 506404 513384 517237 520035 525451 526784 539486 543313 545649 547950 553936 558838 560565 577976 579941 585120 585895 590619 591196 598210 598884 602185 603696 614887 615644 620846 628814 644138 648519 651321 658485 660089 670392 676695 677156 680716 686079 687124 689245 692564 692566 697633 697996 698001 703989 707480 708156 712596 713158 713753 715792 719106 719380 719643 723116 723665 729350 730824 733161 733790 734494 754488 754821 757565 759330 766089 766191 768181 770080 777915 778756 778959 779572 780145 780158 781075 783786 786073 786267 787982 791173 791703 791842 803523 804858 804875 805066 808380 818697 825175 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск любительск глубокийминет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian amateur deepthroat"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.08%) |
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.