Query Metrics
7
Database Queries
7
Different statements
180.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.43 ms (87.10%) |
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 231164 385373 421718 425536 446093 453762 464419 469810 476891 478498 485191 521013 537837 540523 543996 556346 556930 591424 591636 597020 605032 607249 613724 619504 624722 632820 639305 644912 650118 652605 654729 656951 657612 658588 658740 659150 659643 660542 661866 662533 664889 666647 667014 669500 669806 671365 674524 675036 681926 689713 691241 697510 702381 706011 706787 717778 719114 719323 720265 720352 723954 728683 730569 731059 733747 734126 734313 735443 737825 738146 738182 738548 738920 742206 743925 744956 745219 745407 745736 745864 746929 747467 748746 748859 752702 753378 753848 759177 763449 767536 768985 789326 789716 789940 793482 802420 804805 809890 813713 815512 816343 816497 817229 817255 817785 817933 817949 819844 819954 820003 820155 820359 820538 820637 820646 820849 820933 823481 827257 828644 ] |
||||||||||||||||||||||||||||||
|
12.02 ms (6.65%) |
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 656951 657612 658588 658740 659643 660542 661866 664889 669806 675036 689713 706011 706787 719323 720352 591424 607249 639305 613724 624722 591636 597020 619504 789716 793482 804805 731059 733747 745219 767536 802420 734126 734313 738548 745864 768985 723954 730569 737825 744956 745736 748746 759177 763449 728683 735443 738146 738182 738920 742206 743925 745407 753378 753848 746929 747467 748859 752702 605032 632820 697510 702381 717778 719114 720265 789326 789940 809890 385373 231164 421718 425536 816343 819954 820359 820538 820646 644912 816497 817785 827257 815512 817229 817255 817933 817949 820155 820637 820933 813713 819844 820003 820849 823481 828644 453762 469810 478498 446093 464419 476891 485191 537837 540523 521013 556930 543996 556346 650118 652605 654729 659150 662533 666647 667014 669500 671365 674524 681926 691241 ] |
||||||||||||||||||||||||||||||
|
3.53 ms (1.95%) |
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 231164 385373 421718 425536 446093 453762 464419 469810 476891 478498 485191 521013 537837 540523 543996 556346 556930 591424 591636 597020 605032 607249 613724 619504 624722 632820 639305 644912 650118 652605 654729 656951 657612 658588 658740 659150 659643 660542 661866 662533 664889 666647 667014 669500 669806 671365 674524 675036 681926 689713 691241 697510 702381 706011 706787 717778 719114 719323 720265 720352 723954 728683 730569 731059 733747 734126 734313 735443 737825 738146 738182 738548 738920 742206 743925 744956 745219 745407 745736 745864 746929 747467 748746 748859 752702 753378 753848 759177 763449 767536 768985 789326 789716 789940 793482 802420 804805 809890 813713 815512 816343 816497 817229 817255 817785 817933 817949 819844 819954 820003 820155 820359 820538 820637 820646 820849 820933 823481 827257 828644 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"shaving cock"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"shaving cock"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"shaving cock"
]
|
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.