Query Metrics
7
Database Queries
7
Different statements
193.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.24 ms (88.36%) |
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 87363 260350 395388 488576 512811 544677 552385 552386 553701 563382 575238 581289 584956 587753 591919 597829 624028 633009 634597 640879 654680 655503 663223 663309 665789 666402 671494 679593 695693 701425 707729 710784 710819 712377 715179 717958 718853 719211 719821 720082 721650 722121 723138 723256 724567 724685 724688 728160 728165 728865 728866 729434 730455 731140 731407 731572 732598 733297 734025 736154 736497 739205 739542 742973 748350 748743 749417 749592 752082 752933 755615 760302 762243 763293 765041 767346 767521 767781 772371 772799 772826 777452 777928 778753 779403 779410 779533 779638 779822 780233 780281 781036 781186 782970 783724 784196 784339 784686 786821 787229 788090 788316 790057 790131 790289 792208 792915 793964 800046 802326 809541 810391 811849 813323 816778 824081 825455 ] |
||||||||||||||||||||||||||||||
|
12.11 ms (6.25%) |
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 544677 552385 553701 563382 663223 721650 723256 655503 666402 671494 679593 695693 701425 707729 710784 715179 718853 719211 663309 710819 720082 723138 575238 581289 584956 624028 587753 591919 597829 634597 777452 778753 779403 779410 800046 777928 778044 779533 779638 780281 781186 788090 788316 790057 790289 792208 809541 813323 730455 739205 739542 742973 749417 749592 755615 772371 772826 782970 784196 784686 790131 724688 728165 731572 765041 724567 724685 728160 729434 731140 734025 736497 748350 752082 760302 762243 765378 728865 728866 733297 748743 767346 767781 732598 736154 772799 712377 717958 719821 722121 779746 780233 784339 786821 792915 802326 810391 811849 488576 552386 654680 640879 779822 783724 787229 781036 752933 633009 816778 824081 825455 512811 665789 793964 731407 767521 763293 87363 395388 260350 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.53%) |
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 87363 260350 395388 488576 512811 544677 552385 552386 553701 563382 575238 581289 584956 587753 591919 597829 624028 633009 634597 640879 654680 655503 663223 663309 665789 666402 671494 679593 695693 701425 707729 710784 710819 712377 715179 717958 718853 719211 719821 720082 721650 722121 723138 723256 724567 724685 724688 728160 728165 728865 728866 729434 730455 731140 731407 731572 732598 733297 734025 736154 736497 739205 739542 742973 748350 748743 749417 749592 752082 752933 755615 760302 762243 763293 765041 767346 767521 767781 772371 772799 772826 777452 777928 778753 779403 779410 779533 779638 779822 780233 780281 781036 781186 782970 783724 784196 784339 784686 786821 787229 788090 788316 790057 790131 790289 792208 792915 793964 800046 802326 809541 810391 811849 813323 816778 824081 825455 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck in mouth"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс mouth"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс mouth"
]
|
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.