Query Metrics
7
Database Queries
7
Different statements
154.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.97 ms (85.00%) |
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 80035 385166 395388 397777 398428 398617 402892 511495 512811 523809 529608 544969 546557 546563 548831 562451 584233 597000 616060 633742 683468 687391 693527 696220 707555 710218 717972 718830 719751 720217 723590 725053 726316 726356 727387 727511 727608 730985 733196 733386 734036 739634 742565 746219 747010 749566 761435 763191 763232 763293 763322 766399 767816 770026 772256 772290 772376 777990 778740 778929 779582 780250 781032 781034 781553 783318 783438 783706 784063 784084 787231 791009 791825 793929 794959 795975 797552 798503 798537 798927 799711 799903 801699 802281 803418 803692 804040 806872 808251 813981 814050 816778 818843 819704 819786 819798 820091 820202 823982 824944 824970 824973 825020 825120 825174 825179 825180 825205 825356 825380 825464 825779 825861 826145 826216 826298 826374 826929 827108 828368 ] |
||||||||||||||||||||||||||||||
|
12.79 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 780250 794959 548831 693527 778740 777990 783318 397777 80035 824970 826216 819786 819798 820091 820202 823982 825205 825861 826929 825380 824944 828368 781034 730985 398428 402892 385166 816778 696220 544969 803692 749566 720217 791825 511495 808251 512811 727511 763293 726356 778929 523809 824973 827108 825180 766399 814050 825179 825464 825356 529608 799711 767816 633742 826145 772290 787231 398617 395388 813981 825020 825174 723590 826374 826298 818843 819704 825120 825779 562451 584233 687391 717972 718830 683468 710218 719751 707555 546557 546563 616060 597000 779582 781032 783438 798503 798927 802281 804040 783706 791009 797552 799903 801699 725053 742565 746219 761435 763191 763232 763322 772256 781553 784063 784084 793929 795975 798537 803418 806872 727387 734036 739634 747010 770026 772376 726316 727608 733196 733386 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (2.07%) |
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 80035 385166 395388 397777 398428 398617 402892 511495 512811 523809 529608 544969 546557 546563 548831 562451 584233 597000 616060 633742 683468 687391 693527 696220 707555 710218 717972 718830 719751 720217 723590 725053 726316 726356 727387 727511 727608 730985 733196 733386 734036 739634 742565 746219 747010 749566 761435 763191 763232 763293 763322 766399 767816 770026 772256 772290 772376 777990 778740 778929 779582 780250 781032 781034 781553 783318 783438 783706 784063 784084 787231 791009 791825 793929 794959 795975 797552 798503 798537 798927 799711 799903 801699 802281 803418 803692 804040 806872 808251 813981 814050 816778 818843 819704 819786 819798 820091 820202 823982 824944 824970 824973 825020 825120 825174 825179 825180 825205 825356 825380 825464 825779 825861 826145 826216 826298 826374 826929 827108 828368 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck mouth blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс mouth минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс mouth минет оральн секс"
]
|
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.