Query Metrics
7
Database Queries
7
Different statements
181.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.25 ms (87.30%) |
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 53755 322090 392452 395184 396265 396898 398357 398604 398881 402526 417366 440835 440841 440908 445180 451676 469650 471570 500892 512464 517154 528600 534759 538579 542620 550806 553245 566045 578312 600444 603481 608394 611724 614035 614905 619211 630930 632563 632727 632851 634045 635124 643338 644396 646077 652874 653736 653829 657205 659219 661004 662159 662171 665932 667242 673133 673816 675906 676196 684140 689335 690438 694140 696443 696976 702521 703280 709556 712025 714986 715009 715860 716036 716819 719111 720008 720208 721521 726453 730946 731693 732452 735001 739051 745003 745809 748272 751032 756687 758241 758501 758523 759736 761062 762169 764030 767795 768089 774416 775617 776591 780032 785582 786713 788928 788992 791380 794811 799948 804903 807536 810207 810549 812437 813799 820340 820987 822097 827642 ] |
||||||||||||||||||||||||||||||
|
13.51 ms (7.45%) |
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 745003 768089 715860 810549 469650 396898 398881 402526 820987 827642 531192 512464 534759 665932 689335 702521 652874 673133 716036 721521 614035 600444 614905 619211 635124 611724 812437 776591 785582 794811 735001 788928 807536 758523 761062 767795 759736 764030 712025 804903 53755 322090 398604 440908 661004 662159 667242 673816 703280 720008 720208 646077 662171 676196 715009 578312 643338 788992 791380 739051 751032 603481 714986 775617 528600 632563 517154 538579 566045 716819 445180 440835 440841 822097 813799 500892 542620 550806 657205 659219 694140 696443 709556 653736 634045 608394 630930 730946 731693 745809 726453 732452 756687 748272 632727 696976 786713 471570 395184 820340 690438 675906 632851 810207 451676 553245 653829 644396 758501 762169 758241 719111 780032 799948 392452 398357 396265 417366 774416 684140 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.42%) |
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 53755 322090 392452 395184 396265 396898 398357 398604 398881 402526 417366 440835 440841 440908 445180 451676 469650 471570 500892 512464 517154 528600 534759 538579 542620 550806 553245 566045 578312 600444 603481 608394 611724 614035 614905 619211 630930 632563 632727 632851 634045 635124 643338 644396 646077 652874 653736 653829 657205 659219 661004 662159 662171 665932 667242 673133 673816 675906 676196 684140 689335 690438 694140 696443 696976 702521 703280 709556 712025 714986 715009 715860 716036 716819 719111 720008 720208 721521 726453 730946 731693 732452 735001 739051 745003 745809 748272 751032 756687 758241 758501 758523 759736 761062 762169 764030 767795 768089 774416 775617 776591 780032 785582 786713 788928 788992 791380 794811 799948 804903 807536 810207 810549 812437 813799 820340 820987 822097 827642 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"petite fuck"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"petite секс"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"petite секс"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.