Query Metrics
7
Database Queries
7
Different statements
170.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.18 ms (86.43%) |
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 552985 556119 556720 557805 584964 592867 604664 606815 613840 629659 629930 635357 640320 664446 669244 689462 692734 693003 698739 701773 707056 707741 710237 710947 714739 716146 718460 719069 719184 719793 720006 720542 722152 722168 723476 724130 724167 724461 725020 725240 726438 728116 728464 728634 728810 728868 728870 728921 730309 730318 730510 730679 730742 731125 733389 733448 734295 734448 734590 734604 736671 740614 741319 744362 746132 746853 747056 747061 748038 748445 749791 750647 752511 753506 753988 756979 757930 760768 761339 761378 763191 764850 764934 765369 767294 767629 767734 767870 767884 767892 768542 768719 768720 772354 773116 773375 775527 779645 782043 787412 790709 794546 794565 794692 795063 796755 796835 799434 800045 801478 801673 802173 803903 804659 809908 809996 811188 811368 811650 ] |
||||||||||||||||||||||||||||||
|
14.29 ms (8.39%) |
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 556119 557805 552985 584964 664446 693003 701773 707056 707741 719184 720542 722152 722168 723476 689462 698739 716146 669244 692734 710237 710947 714739 718460 719069 719793 720006 556720 592867 640320 604664 613840 635357 629930 606815 629659 782043 790709 794546 795063 799434 802173 811188 811368 775527 779645 794565 796755 796835 801673 804659 728634 734448 736671 750647 752511 753506 760768 761339 761378 763191 764850 767629 772354 773116 785402 787412 794692 800045 801478 803903 809908 809996 811650 725020 725240 728921 730309 734590 744362 748038 764934 767734 767870 767884 767892 724461 726438 733389 734295 746132 747056 747061 756979 757930 724130 724167 728116 728464 728868 728870 730510 730679 730742 753988 765369 767294 768542 768719 768720 728810 730318 731125 733448 734604 740614 741319 746853 748445 749791 773375 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.56%) |
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 552985 556119 556720 557805 584964 592867 604664 606815 613840 629659 629930 635357 640320 664446 669244 689462 692734 693003 698739 701773 707056 707741 710237 710947 714739 716146 718460 719069 719184 719793 720006 720542 722152 722168 723476 724130 724167 724461 725020 725240 726438 728116 728464 728634 728810 728868 728870 728921 730309 730318 730510 730679 730742 731125 733389 733448 734295 734448 734590 734604 736671 740614 741319 744362 746132 746853 747056 747061 748038 748445 749791 750647 752511 753506 753988 756979 757930 760768 761339 761378 763191 764850 764934 765369 767294 767629 767734 767870 767884 767892 768542 768719 768720 772354 773116 773375 775527 779645 782043 787412 790709 794546 794565 794692 795063 796755 796835 799434 800045 801478 801673 802173 803903 804659 809908 809996 811188 811368 811650 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cumshot жен"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cumshot wife"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cumshot жен"
]
|
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.