Query Metrics
7
Database Queries
7
Different statements
376.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.80 ms (55.39%) |
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 16913 181422 187956 187992 266633 397216 398733 536365 537964 538192 547422 557328 560923 563730 564298 564303 564543 576566 584035 584391 592509 597132 598479 604169 623195 623273 624360 629146 629735 630392 636885 638423 643461 649580 652397 654409 656562 666378 669955 690443 692104 696232 698554 699976 701396 702941 703297 714888 715549 717258 719373 720408 721562 725556 726175 727290 731228 731274 731363 734970 738731 739164 740243 740751 742748 747751 749322 750283 754034 760894 761103 761587 765101 766608 767077 767140 767147 768761 773686 774147 775563 776981 778644 779665 779695 780750 783372 783386 783436 786316 788557 788985 790028 791155 791800 792946 794782 797130 800364 800713 800830 801285 806858 807135 807609 813944 816635 816985 817155 817215 817328 818051 821704 824425 824679 824763 827835 827951 828191 ] |
||||||||||||||||||||||||||||||
|
151.65 ms (40.23%) |
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 16913 181422 187956 187992 266633 397216 398733 536365 537964 538192 547422 557328 560923 563730 564298 564303 564543 576566 584035 584391 592509 597132 598479 604169 623195 623273 624360 629146 629735 630392 636885 638423 643461 649580 652397 654409 656562 666378 669955 690443 692104 696232 698554 699976 701396 702941 703297 714888 715549 717258 719373 720408 721562 725556 726175 727290 731228 731274 731363 734970 738731 739164 740243 740751 742748 747751 749322 750283 754034 760894 761103 761587 765101 766608 767077 767140 767147 768761 773686 774147 775563 776981 778644 779665 779695 780750 783372 783386 783436 786316 788557 788985 790028 791155 791800 792946 794782 797130 800364 800713 800830 801285 806858 807135 807609 813944 816635 816985 817155 817215 817328 818051 821704 824425 824679 824763 827835 827951 828191 ] |
||||||||||||||||||||||||||||||
|
10.63 ms (2.82%) |
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 816985 816635 817155 828191 538192 536365 537964 563730 584035 564303 576566 699976 692104 592509 636885 775563 791800 786316 738731 727290 767147 779695 767077 765101 800830 187992 800713 187956 821704 584391 703297 702941 649580 654409 696232 721562 598479 643461 604169 776981 801285 731228 731274 783372 807609 774147 747751 749322 768761 761103 780750 564298 560923 638423 783386 739164 734970 750283 766608 717258 779665 788557 669955 754034 726175 629146 790028 16913 827951 398733 813944 827835 698554 690443 714888 656562 557328 564543 597132 629735 623273 630392 778644 725556 761587 792946 797130 806858 760894 773686 742748 731363 783436 788985 807135 623195 397216 720408 719373 740751 794782 800364 740243 266633 767140 824425 715549 181422 816642 817215 818051 824763 817328 824679 547422 652397 666378 701396 624360 791155 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal sex ass"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал секс жоп"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.39%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.23 ms (0.33%) |
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.