Query Metrics
7
Database Queries
7
Different statements
152.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.45 ms (83.40%) |
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 335196 387422 390445 397255 398947 425998 437583 461358 465791 478107 479493 482328 515060 525557 526515 530341 531482 533562 535985 547265 563182 563443 565155 586636 586826 589522 590291 599209 610271 615759 616188 621682 624497 627728 631988 638147 641082 651186 655295 663519 663941 665943 677949 678761 689566 697381 702966 710078 711674 712707 713576 716898 717036 721167 723731 726328 729612 744982 746107 755463 755810 758171 760133 763024 765185 765313 766385 770874 771374 771933 774918 776189 779320 780930 781907 782503 784304 785038 785479 788156 788947 788979 793370 796730 797639 797846 798643 799282 799399 800126 801353 801760 805700 806071 806164 806201 806204 808335 813667 815359 815751 815758 815912 816508 816951 817278 817842 817878 817879 817949 818354 818448 821250 821495 822637 822657 823292 823473 823563 824179 ] |
||||||||||||||||||||||||||||||
|
15.59 ms (10.20%) |
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 817842 815912 816508 817949 461358 515060 547265 563182 565155 799282 800126 801760 806204 755463 387422 425998 784304 813667 817879 818448 821495 824179 821250 535985 525557 663519 663941 665943 678761 712707 713576 615759 774918 808335 779320 788947 760133 763024 765313 805700 726328 755810 711674 788979 770874 616188 723731 610271 823563 798643 729612 482328 563443 478107 437583 465791 815751 818354 697381 590291 599209 586636 627728 793370 776189 797846 806201 765185 788156 624497 638147 781907 797639 806164 398947 526515 390445 689566 335196 823292 822637 530341 531482 710078 651186 717036 721167 782503 806071 746107 801353 822657 815758 823473 815359 816951 479493 533562 655295 677949 716898 702966 631988 586826 589522 641082 766385 785038 785479 796730 744982 758171 771933 780930 799399 397255 621682 771374 817878 817278 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.98%) |
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 335196 387422 390445 397255 398947 425998 437583 461358 465791 478107 479493 482328 515060 525557 526515 530341 531482 533562 535985 547265 563182 563443 565155 586636 586826 589522 590291 599209 610271 615759 616188 621682 624497 627728 631988 638147 641082 651186 655295 663519 663941 665943 677949 678761 689566 697381 702966 710078 711674 712707 713576 716898 717036 721167 723731 726328 729612 744982 746107 755463 755810 758171 760133 763024 765185 765313 766385 770874 771374 771933 774918 776189 779320 780930 781907 782503 784304 785038 785479 788156 788947 788979 793370 796730 797639 797846 798643 799282 799399 800126 801353 801760 805700 806071 806164 806201 806204 808335 813667 815359 815751 815758 815912 816508 816951 817278 817842 817878 817879 817949 818354 818448 821250 821495 822637 822657 823292 823473 823563 824179 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck mom shower"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс mom shower"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс mom shower"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.95%) |
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.