Query Metrics
7
Database Queries
7
Different statements
144.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.88 ms (85.04%) |
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 22843 160249 191069 237173 397063 397915 398196 408622 441541 462989 469224 494546 496829 499306 508904 521742 521746 530595 532884 533107 536008 549601 550566 552254 565234 565307 568436 569183 574148 574193 575775 578353 578711 580606 584307 584743 586693 589979 605067 607850 609347 610276 627279 629996 632626 636117 645643 645777 645972 646076 649785 651987 655170 655193 655225 655251 656556 673807 681456 686341 698936 705024 707584 710432 714249 719347 720152 723300 727639 728761 729674 738839 739016 740194 744478 745584 750407 751751 752268 755200 756729 761224 761520 764920 765615 765705 766140 770375 773402 775653 776425 778930 779659 779695 780269 783076 783990 785740 786687 787718 787933 788062 790216 790865 795037 796406 796765 796883 799198 806990 807932 817965 818122 821631 822726 823469 827563 827885 828727 ] |
||||||||||||||||||||||||||||||
|
12.25 ms (8.48%) |
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 727639 645972 744478 574148 508904 673807 610276 779659 651987 786687 568436 751751 584307 584743 521746 578711 552254 494546 632626 496829 569183 783990 575775 740194 827563 828727 776425 714249 645777 806990 655170 773402 536008 499306 408622 779695 729674 441541 646076 698936 636117 761520 707584 533107 756729 761224 787718 818122 586693 398196 755200 827885 795037 655225 723300 780269 530595 549601 565307 578353 681456 645643 686341 764920 629996 750407 397915 22843 397063 580606 710432 720152 627279 783076 766140 160249 728761 765615 821631 823469 705024 532884 719347 764783 469224 565234 655251 609347 787933 655193 656556 778930 605067 822726 799198 807932 796765 739016 788062 738839 770375 785740 550566 237173 817965 191069 462989 521742 649785 775653 790216 796406 796883 745584 752268 765705 790865 574193 589979 607850 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.87%) |
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 22843 160249 191069 237173 397063 397915 398196 408622 441541 462989 469224 494546 496829 499306 508904 521742 521746 530595 532884 533107 536008 549601 550566 552254 565234 565307 568436 569183 574148 574193 575775 578353 578711 580606 584307 584743 586693 589979 605067 607850 609347 610276 627279 629996 632626 636117 645643 645777 645972 646076 649785 651987 655170 655193 655225 655251 656556 673807 681456 686341 698936 705024 707584 710432 714249 719347 720152 723300 727639 728761 729674 738839 739016 740194 744478 745584 750407 751751 752268 755200 756729 761224 761520 764920 765615 765705 766140 770375 773402 775653 776425 778930 779659 779695 780269 783076 783990 785740 786687 787718 787933 788062 790216 790865 795037 796406 796765 796883 799198 806990 807932 817965 818122 821631 822726 823469 827563 827885 828727 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"little girls ass"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"little девушк жоп"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"little девушк жоп"
]
|
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.