Query Metrics
7
Database Queries
7
Different statements
145.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.64 ms (85.25%) |
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 3599 7449 7456 51569 69950 187186 187443 213598 381813 382591 383567 387230 389945 395887 396424 397479 411902 428141 449082 450104 450122 451470 453276 454023 468088 468357 471053 471390 486350 490918 493094 521712 526731 530546 531033 531390 555970 560430 565684 577185 579721 582581 599202 602600 602678 604303 618468 637293 645952 652099 660714 665497 666099 667266 707428 710581 710868 715414 720516 721421 721461 721498 721562 725196 725657 726698 726896 728208 728891 728921 733081 733334 734693 735925 736047 736242 738901 740715 741700 742385 744188 745991 746678 747196 749050 752627 757246 759927 759950 760580 761030 762796 774331 776725 781683 781704 782294 784006 788287 790991 791482 797240 797262 801110 806540 810244 812094 812516 816875 816991 817562 817575 817775 818824 819031 819719 821238 824022 824184 826048 ] |
||||||||||||||||||||||||||||||
|
13.46 ms (9.28%) |
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 745991 762796 791482 736242 740715 728891 602678 782294 381813 187443 396424 824022 468357 721461 721498 652099 665497 667266 579721 599202 726698 757246 741700 774331 736047 752627 761030 707428 450104 555970 213598 7456 817562 819031 819719 660714 720516 721562 602600 637293 733334 812094 725196 746678 759927 747196 776725 7449 471390 742385 471053 490918 389945 818824 449082 526731 531390 468088 493094 582581 565684 721421 666099 715414 618468 781704 788287 734693 781683 797240 797262 726896 759950 738901 710581 451470 450122 486350 560430 645952 69950 51569 3599 816875 826048 824184 816991 817575 817775 821238 454023 530546 531033 521712 577185 710868 604303 784006 810244 735925 806540 728921 744188 728208 749050 725657 733081 760580 790991 801110 812516 383567 187186 395887 382591 387230 397479 411902 428141 453276 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.75%) |
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 3599 7449 7456 51569 69950 187186 187443 213598 381813 382591 383567 387230 389945 395887 396424 397479 411902 428141 449082 450104 450122 451470 453276 454023 468088 468357 471053 471390 486350 490918 493094 521712 526731 530546 531033 531390 555970 560430 565684 577185 579721 582581 599202 602600 602678 604303 618468 637293 645952 652099 660714 665497 666099 667266 707428 710581 710868 715414 720516 721421 721461 721498 721562 725196 725657 726698 726896 728208 728891 728921 733081 733334 734693 735925 736047 736242 738901 740715 741700 742385 744188 745991 746678 747196 749050 752627 757246 759927 759950 760580 761030 762796 774331 776725 781683 781704 782294 784006 788287 790991 791482 797240 797262 801110 806540 810244 812094 812516 816875 816991 817562 817575 817775 818824 819031 819719 821238 824022 824184 826048 ] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature sexy"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.31 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature sexy"
]
|
||||||||||||||||||||||||||||||
|
1.01 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature sexy"
]
|
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.