Query Metrics
7
Database Queries
7
Different statements
137.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
114.26 ms (82.89%) |
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 546160 550800 567618 569069 577034 583539 587151 588390 590835 592655 594803 595591 600830 602318 605934 612291 616846 617994 618228 618238 618393 619387 619443 619699 620332 622303 625504 631298 632993 634080 634741 641161 642966 651596 660383 661962 672913 677979 678837 678850 680455 681969 697100 698436 705305 707479 707577 708570 708578 709397 711133 712386 712646 712801 713297 715362 727008 730246 730808 731758 735135 739566 739598 740257 740457 743262 743272 743998 744775 745036 745375 746197 746374 748311 748648 751426 755943 756149 756249 756549 757223 757283 761112 762184 766398 766591 767173 768219 769113 772478 778759 783323 783398 784462 784480 785366 785651 786307 787531 789785 790442 792724 792943 793072 798764 799854 801531 802219 802328 802352 805584 805588 806555 806681 807160 809077 810168 811331 ] |
||||||||||||||||||||||||||||||
|
13.39 ms (9.71%) |
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 569069 651596 661962 678837 680455 708578 660383 678850 705305 707479 708570 712646 712801 672913 677979 681969 709397 712386 546160 550800 567618 577034 583539 587151 588390 605934 616846 618238 619443 625504 595591 600830 618228 618393 622303 617994 620332 632993 590835 592655 594803 612291 619699 631298 641161 784462 785366 790442 792943 798764 802352 805588 807160 809077 811331 778759 783323 785651 787531 792724 793072 806555 743262 745036 746197 746374 748311 756249 756549 768219 769113 783398 784480 786307 789785 799854 801531 802219 802328 805584 806681 810168 730808 740257 740457 751426 755943 772478 727008 731758 744775 745375 748648 757223 766525 766591 739566 739598 743998 756149 766398 768254 730246 735135 743272 757283 761112 762184 767173 602318 619387 634080 634741 642966 697100 698436 707577 711133 713297 715362 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (2.27%) |
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 546160 550800 567618 569069 577034 583539 587151 588390 590835 592655 594803 595591 600830 602318 605934 612291 616846 617994 618228 618238 618393 619387 619443 619699 620332 622303 625504 631298 632993 634080 634741 641161 642966 651596 660383 661962 672913 677979 678837 678850 680455 681969 697100 698436 705305 707479 707577 708570 708578 709397 711133 712386 712646 712801 713297 715362 727008 730246 730808 731758 735135 739566 739598 740257 740457 743262 743272 743998 744775 745036 745375 746197 746374 748311 748648 751426 755943 756149 756249 756549 757223 757283 761112 762184 766398 766591 767173 768219 769113 772478 778759 783323 783398 784462 784480 785366 785651 786307 787531 789785 790442 792724 792943 793072 798764 799854 801531 802219 802328 802352 805584 805588 806555 806681 807160 809077 810168 811331 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy toys"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy toys"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy toys"
]
|
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.