Query Metrics
7
Database Queries
7
Different statements
190.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.77 ms (88.78%) |
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 8043 8207 38292 51659 68658 68967 72666 74965 80505 100535 143291 196422 229010 334299 383149 384562 385794 387773 389859 393408 393417 395271 396969 398225 398847 399609 402513 419214 450180 513184 525528 534482 537246 543373 543800 548699 557180 557183 565059 572403 574979 580844 606623 618336 625428 626340 627114 630513 634473 644883 650096 652829 667749 668554 672981 674249 682644 683570 693515 694389 694692 695697 697325 701971 716482 721270 721767 724418 729267 730550 731766 734462 737413 738509 739624 744881 745055 745795 746638 746679 749319 752949 760124 762041 762426 764927 765442 768334 769568 771568 774221 775571 776290 776512 776526 777801 782410 782939 785496 786319 786766 793474 793693 796828 797881 799566 801623 801801 811735 814251 814339 816529 817550 817755 819196 821986 822016 823521 828407 ] |
||||||||||||||||||||||||||||||
|
12.02 ms (6.32%) |
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 746679 724418 746638 385794 716482 821986 606623 630513 782410 762041 774221 229010 396969 537246 51659 694692 393408 399609 819196 534482 625428 799566 729267 734462 745795 721270 580844 627114 695697 634473 762426 777801 72666 793693 739624 383149 801623 721767 100535 395271 513184 730550 744881 768334 737413 801801 769568 816529 814339 574979 557183 777560 776526 196422 822016 694389 796828 776512 786766 764927 745055 814251 68967 402513 771568 775571 749319 387773 697325 548699 668554 701971 682644 786319 776290 398847 811735 674249 817550 823521 644883 525528 572403 618336 797881 731766 738509 785496 393417 817755 543373 557180 650096 782939 793474 8043 334299 683570 693515 450180 672981 68658 828407 543800 667749 8207 565059 652829 74965 80505 398225 389859 760124 143291 626340 384562 38292 419214 765442 752949 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.26%) |
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 8043 8207 38292 51659 68658 68967 72666 74965 80505 100535 143291 196422 229010 334299 383149 384562 385794 387773 389859 393408 393417 395271 396969 398225 398847 399609 402513 419214 450180 513184 525528 534482 537246 543373 543800 548699 557180 557183 565059 572403 574979 580844 606623 618336 625428 626340 627114 630513 634473 644883 650096 652829 667749 668554 672981 674249 682644 683570 693515 694389 694692 695697 697325 701971 716482 721270 721767 724418 729267 730550 731766 734462 737413 738509 739624 744881 745055 745795 746638 746679 749319 752949 760124 762041 762426 764927 765442 768334 769568 771568 774221 775571 776290 776512 776526 777801 782410 782939 785496 786319 786766 793474 793693 796828 797881 799566 801623 801801 811735 814251 814339 816529 817550 817755 819196 821986 822016 823521 828407 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob tits"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.79%) |
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.