Query Metrics
7
Database Queries
7
Different statements
190.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.32 ms (86.83%) |
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 386354 389612 390643 390772 391718 393765 393770 396285 400455 400461 400463 401041 402090 403190 403210 411927 415906 444834 445040 456656 462288 464315 466821 467320 469905 474876 480006 489619 492392 495024 501442 512041 512047 515092 515120 515135 515160 515171 515202 515215 515216 515234 528344 529206 538660 557148 557270 557304 566517 567153 568573 569668 569677 569686 570069 578461 585997 593440 597259 621657 622888 644697 655861 663439 663482 663507 663940 663947 664281 664307 664957 666123 667209 667543 676930 684187 688032 691993 693073 693301 696973 700541 700945 705093 707347 709591 714155 716450 720456 721006 732421 736022 740114 741647 742689 743082 743116 744328 744443 748143 751648 756097 758198 759593 765445 765446 766035 771180 778419 779207 788647 798897 800629 810312 813905 817622 817630 818936 823700 828053 ] |
||||||||||||||||||||||||||||||
|
15.40 ms (8.09%) |
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 732421 743116 788647 390643 389612 445040 391718 817630 684187 700541 557270 705093 622888 515135 621657 569686 688032 766035 741647 720456 462288 469905 512041 515234 569677 817622 798897 813905 467320 663940 666123 667209 676930 716450 663439 700945 566517 593440 597259 736022 743082 756097 721006 778419 474876 480006 466821 663947 557304 515160 567153 495024 569668 529206 740114 401041 693301 709591 800629 765445 765446 444834 568573 557148 515216 691993 663482 396285 393765 538660 663507 492392 515202 714155 823700 828053 400461 515120 655861 693073 748143 744328 742689 411927 759593 402090 664307 810312 400463 501442 751648 528344 515171 403190 403210 456656 512047 707347 696973 585997 771180 758198 644697 393770 779207 744443 664281 386354 390772 400455 415906 818936 489619 464315 515215 515092 570069 578461 667543 664957 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.25%) |
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 386354 389612 390643 390772 391718 393765 393770 396285 400455 400461 400463 401041 402090 403190 403210 411927 415906 444834 445040 456656 462288 464315 466821 467320 469905 474876 480006 489619 492392 495024 501442 512041 512047 515092 515120 515135 515160 515171 515202 515215 515216 515234 528344 529206 538660 557148 557270 557304 566517 567153 568573 569668 569677 569686 570069 578461 585997 593440 597259 621657 622888 644697 655861 663439 663482 663507 663940 663947 664281 664307 664957 666123 667209 667543 676930 684187 688032 691993 693073 693301 696973 700541 700945 705093 707347 709591 714155 716450 720456 721006 732421 736022 740114 741647 742689 743082 743116 744328 744443 748143 751648 756097 758198 759593 765445 765446 766035 771180 778419 779207 788647 798897 800629 810312 813905 817622 817630 818936 823700 828053 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old young fuck"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old young секс"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old young секс"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.77%) |
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.