Query Metrics
7
Database Queries
7
Different statements
174.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.20 ms (85.58%) |
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 13258 14369 14602 25030 130468 161342 272014 381734 382078 383477 384803 385915 388774 393652 393673 395492 396336 396704 396706 396709 396730 397980 398666 399028 400787 401625 405043 406172 408238 418839 420695 447740 457240 464345 464633 469581 478491 480422 517154 520157 521579 527761 529792 531710 532708 534322 536579 537912 537936 540511 542212 543852 546804 583982 589551 601599 606528 610042 617421 618074 629412 629560 630550 632020 634528 636032 642038 643263 644246 645952 646427 647972 653052 665763 670109 673767 673776 673969 676636 679798 695181 696983 700678 707290 711281 713052 714552 716868 718930 718944 720119 720295 720873 721870 725171 732271 732292 732450 734692 738241 740641 741306 742137 744656 746837 750277 756394 766842 771834 780601 780662 793662 800296 804013 815837 816979 817062 817065 817208 824937 ] |
||||||||||||||||||||||||||||||
|
14.70 ms (8.43%) |
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 665763 618074 393673 771834 383477 397980 738241 393652 718930 653052 642038 589551 817062 750277 700678 711281 780601 780662 804013 385915 536579 645952 673776 718944 673969 741306 521579 420695 457240 720119 408238 382078 707290 400787 13258 673767 696983 713052 636032 800296 732450 634528 543852 695181 384803 396704 720873 583982 632020 14602 464345 396336 398666 395492 464633 418839 610042 529792 647972 676636 396709 720295 388774 399028 25030 617421 517154 646427 630550 447740 816979 531710 629412 725171 793662 766842 670109 546804 405043 469581 480422 401625 732292 396706 716868 679798 606528 714552 721870 817208 742137 396730 532708 744656 537912 537936 542212 629560 478491 381734 734692 815837 817065 824937 644246 746837 740641 732271 756394 406172 534322 601599 520157 643263 14369 130468 161342 272014 540511 527761 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.69%) |
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 13258 14369 14602 25030 130468 161342 272014 381734 382078 383477 384803 385915 388774 393652 393673 395492 396336 396704 396706 396709 396730 397980 398666 399028 400787 401625 405043 406172 408238 418839 420695 447740 457240 464345 464633 469581 478491 480422 517154 520157 521579 527761 529792 531710 532708 534322 536579 537912 537936 540511 542212 543852 546804 583982 589551 601599 606528 610042 617421 618074 629412 629560 630550 632020 634528 636032 642038 643263 644246 645952 646427 647972 653052 665763 670109 673767 673776 673969 676636 679798 695181 696983 700678 707290 711281 713052 714552 716868 718930 718944 720119 720295 720873 721870 725171 732271 732292 732450 734692 738241 740641 741306 742137 744656 746837 750277 756394 766842 771834 780601 780662 793662 800296 804013 815837 816979 817062 817065 817208 824937 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc blowjob anal"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc минет оральн секс анал"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc минет оральн секс анал"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.00%) |
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.