Query Metrics
7
Database Queries
7
Different statements
146.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.22 ms (82.92%) |
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 39167 76853 326944 384406 385166 398428 398617 402892 444930 453508 463661 469271 477193 493019 496793 508921 519251 530216 541946 544969 545851 546557 546563 562763 583643 584211 584233 589030 590604 616060 625743 628102 634503 658481 670449 683468 687391 689160 692363 703409 710218 715746 716599 716621 717972 718830 720084 720169 722189 723151 723590 725453 726344 726356 727511 727536 731384 732133 734304 740045 754213 763292 765410 768190 772290 777461 778929 779582 779767 781032 781408 781537 787231 787585 791086 791702 793345 793456 793756 794959 796046 798305 798503 802281 803692 804040 814281 814310 817971 818697 818843 819704 819786 819798 820091 820202 823763 823783 823982 824712 824944 824970 825076 825110 825174 825205 825380 825391 825434 825850 825861 825963 826145 826216 826298 826374 826929 827209 828368 ] |
||||||||||||||||||||||||||||||
|
14.79 ms (10.11%) |
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 463661 477193 496793 827209 740045 384406 824970 825391 825850 826216 823763 819786 819798 820091 820202 823982 825205 825963 825861 826929 823783 825380 824944 828368 777461 720169 398428 402892 385166 590604 814310 541946 544969 793345 793756 798305 803692 731384 703409 519251 545851 826145 824712 716599 726344 781408 791702 732133 772290 787231 398617 530216 453508 444930 39167 670449 793456 727511 726356 763292 778929 825076 508921 692363 715746 589030 787585 791086 727536 734304 768190 765410 720084 722189 562763 493019 76853 326944 825434 628102 725453 794959 754213 796046 817971 825174 723590 818697 825110 826374 826298 814281 818843 819704 469271 584233 687391 689160 716621 717972 718830 658481 683468 710218 698164 723151 546557 546563 583643 584211 616060 634503 625743 779582 779767 781032 781537 798503 802281 804040 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (2.03%) |
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 39167 76853 326944 384406 385166 398428 398617 402892 444930 453508 463661 469271 477193 493019 496793 508921 519251 530216 541946 544969 545851 546557 546563 562763 583643 584211 584233 589030 590604 616060 625743 628102 634503 658481 670449 683468 687391 689160 692363 703409 710218 715746 716599 716621 717972 718830 720084 720169 722189 723151 723590 725453 726344 726356 727511 727536 731384 732133 734304 740045 754213 763292 765410 768190 772290 777461 778929 779582 779767 781032 781408 781537 787231 787585 791086 791702 793345 793456 793756 794959 796046 798305 798503 802281 803692 804040 814281 814310 817971 818697 818843 819704 819786 819798 820091 820202 823763 823783 823982 824712 824944 824970 825076 825110 825174 825205 825380 825391 825434 825850 825861 825963 826145 826216 826298 826374 826929 827209 828368 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum минет оральн секс"
]
|
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.