Query Metrics
7
Database Queries
7
Different statements
154.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.00 ms (85.55%) |
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 32549 56349 57253 73926 145660 145988 383407 383434 384058 385682 386322 389182 389496 391134 397068 404083 409050 412518 413612 419839 429583 431471 442280 453124 453154 457263 463295 464546 468616 474078 490632 492102 500472 501527 502033 502061 504614 536096 543989 548394 549292 553107 554435 557412 557707 558367 561725 561773 561775 576499 577057 587587 590724 593240 603345 609554 610138 630260 649952 660711 671837 686088 697296 712298 714332 716911 719108 719146 719159 719193 720004 720344 720455 722470 723966 725580 726860 727545 730847 731482 732204 732236 733223 734565 741980 744140 759731 761271 767560 771808 775628 780673 793533 793612 795915 795918 796494 802429 803079 804398 809926 810383 810861 813172 814117 814402 815222 815766 818396 820453 823916 824953 825137 825251 826455 826642 826695 826835 827377 827789 ] |
||||||||||||||||||||||||||||||
|
12.37 ms (8.01%) |
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 419839 548394 557707 590724 759731 145660 145988 712298 722470 720004 720455 725580 809926 719146 780673 431471 660711 796494 397068 383434 775628 826695 825251 827789 557412 793533 826835 561773 457263 389182 824953 468616 463295 561725 553107 720344 697296 793612 810383 741980 802429 404083 826642 818396 383407 814402 714332 500472 732204 384058 57253 823916 442280 412518 826455 827377 744140 502033 558367 561775 671837 815766 686088 719108 549292 577057 810861 733223 723966 767560 73926 825137 56349 429583 814117 453124 453154 502061 587587 630260 795915 730847 32549 464546 609554 474078 413612 554435 734565 761271 386322 409050 719159 603345 731482 726860 536096 576499 593240 610138 727545 716911 813172 389496 385682 492102 501527 543989 649952 795918 391134 490632 820453 815222 804398 771808 803079 732236 719193 504614 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.65%) |
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 32549 56349 57253 73926 145660 145988 383407 383434 384058 385682 386322 389182 389496 391134 397068 404083 409050 412518 413612 419839 429583 431471 442280 453124 453154 457263 463295 464546 468616 474078 490632 492102 500472 501527 502033 502061 504614 536096 543989 548394 549292 553107 554435 557412 557707 558367 561725 561773 561775 576499 577057 587587 590724 593240 603345 609554 610138 630260 649952 660711 671837 686088 697296 712298 714332 716911 719108 719146 719159 719193 720004 720344 720455 722470 723966 725580 726860 727545 730847 731482 732204 732236 733223 734565 741980 744140 759731 761271 767560 771808 775628 780673 793533 793612 795915 795918 796494 802429 803079 804398 809926 810383 810861 813172 814117 814402 815222 815766 818396 820453 823916 824953 825137 825251 826455 826642 826695 826835 827377 827789 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"lick hairy pussy"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза волосатая pussy"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лиза волосатая pussy"
]
|
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.