Query Metrics
7
Database Queries
7
Different statements
180.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.97 ms (87.55%) |
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 358453 373724 410299 418534 425431 443086 452641 452964 468220 496076 520419 531565 537972 548969 548973 549004 554827 567684 576534 584346 591006 593809 599939 603634 604184 604358 609288 612905 619668 620975 620977 623275 624302 629711 630341 630345 631526 632921 636941 641006 648410 651510 651731 656484 656582 656826 656888 657536 660701 661656 661973 663715 668085 672272 692040 692096 693441 693492 696104 698841 703625 704023 707217 707558 707608 715700 715934 719919 721959 721977 722378 723158 726229 728669 729290 734411 734452 734964 736283 736809 737444 740087 742362 747625 751308 752752 756331 757052 758504 760436 761762 765097 767154 767257 767804 769033 769846 769895 772783 773384 774698 777028 778390 778424 778878 778893 781368 782436 783349 785855 791157 793266 794378 795920 801312 814533 823719 824579 826804 ] |
||||||||||||||||||||||||||||||
|
12.57 ms (6.97%) |
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 777028 767804 751308 612905 778878 757052 769846 734964 772783 604184 418534 452641 520419 443086 425431 452964 373724 824579 531565 468220 778424 756331 742362 794378 537972 549004 584346 651510 651731 656582 661973 668085 693441 703625 648410 656484 660701 663715 672272 693492 696104 698841 707217 707558 707608 656888 657536 661656 692096 630341 636941 591006 593809 603634 619668 620977 624302 629711 599939 604358 609288 630345 791157 734988 726229 631526 632921 641006 704023 721959 692040 358453 410299 814533 823719 826804 496076 548973 567684 719919 722378 656826 715700 715934 721977 723158 548969 554827 576534 620975 623275 774698 778893 785855 793266 801312 778390 781368 782436 783349 795920 728669 729290 734411 734452 736283 736809 737444 740087 747625 752752 758504 760436 761762 765097 767154 767257 769033 769895 773384 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.57%) |
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 358453 373724 410299 418534 425431 443086 452641 452964 468220 496076 520419 531565 537972 548969 548973 549004 554827 567684 576534 584346 591006 593809 599939 603634 604184 604358 609288 612905 619668 620975 620977 623275 624302 629711 630341 630345 631526 632921 636941 641006 648410 651510 651731 656484 656582 656826 656888 657536 660701 661656 661973 663715 668085 672272 692040 692096 693441 693492 696104 698841 703625 704023 707217 707558 707608 715700 715934 719919 721959 721977 722378 723158 726229 728669 729290 734411 734452 734964 736283 736809 737444 740087 742362 747625 751308 752752 756331 757052 758504 760436 761762 765097 767154 767257 767804 769033 769846 769895 772783 773384 774698 777028 778390 778424 778878 778893 781368 782436 783349 785855 791157 793266 794378 795920 801312 814533 823719 824579 826804 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam amateur anal"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер любительск анал"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.87%) |
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.