Query Metrics
7
Database Queries
7
Different statements
174.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.03 ms (84.81%) |
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 187171 389511 394258 395634 395904 407458 409383 419147 439723 442634 443468 443668 448961 450118 450136 450155 453730 455966 469402 470100 470264 474182 475469 485698 486549 495221 496104 496949 500412 504655 509082 513581 513583 520656 525269 528081 531228 531963 534716 539337 541313 541379 554390 555088 557591 571745 597150 598862 604928 607529 614407 620237 644104 645274 647856 668983 670223 672764 674087 681609 701182 710505 711732 715879 715908 720530 725547 726486 728352 732744 738335 741759 741772 741777 742591 742751 742761 743003 744419 745938 746121 761557 764186 765313 765554 772879 789741 793097 794106 794700 795963 796072 799962 800725 800750 800760 800921 800927 803426 804503 807499 808256 813578 815022 818367 820378 823266 825328 825362 825388 825429 825976 826086 826195 826557 826682 826689 826789 827203 827315 ] |
||||||||||||||||||||||||||||||
|
15.62 ms (8.95%) |
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 419147 407458 496104 672764 800927 485698 513583 455966 495221 795963 448961 813578 474182 470264 496949 504655 520656 541313 674087 598862 794106 800725 746121 742751 711732 443468 475469 796072 710505 818367 571745 807499 725547 395634 394258 453730 761557 443668 728352 442634 486549 647856 745938 799962 825976 825388 820378 827203 815022 509082 701182 715879 715908 644104 808256 720530 528081 732744 541379 555088 439723 825328 450136 450155 469402 668983 741772 741777 742591 800921 744419 741759 803426 450118 500412 525269 738335 772879 793097 531228 554390 187171 389511 620237 614407 765554 764186 395904 513581 557591 645274 726486 409383 470100 823266 825429 826682 826689 826557 825362 826789 826195 826086 827315 534716 539337 531963 670223 681609 597150 604928 607529 804503 789741 794700 800750 800760 743003 765313 742761 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.48%) |
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 187171 389511 394258 395634 395904 407458 409383 419147 439723 442634 443468 443668 448961 450118 450136 450155 453730 455966 469402 470100 470264 474182 475469 485698 486549 495221 496104 496949 500412 504655 509082 513581 513583 520656 525269 528081 531228 531963 534716 539337 541313 541379 554390 555088 557591 571745 597150 598862 604928 607529 614407 620237 644104 645274 647856 668983 670223 672764 674087 681609 701182 710505 711732 715879 715908 720530 725547 726486 728352 732744 738335 741759 741772 741777 742591 742751 742761 743003 744419 745938 746121 761557 764186 765313 765554 772879 789741 793097 794106 794700 795963 796072 799962 800725 800750 800760 800921 800927 803426 804503 807499 808256 813578 815022 818367 820378 823266 825328 825362 825388 825429 825976 826086 826195 826557 826682 826689 826789 827203 827315 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature минет оральн секс cum"
]
|
||||||||||||||||||||||||||||||
|
2.21 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature blowjob cum"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature минет оральн секс cum"
]
|
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.