Query Metrics
7
Database Queries
7
Different statements
189.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.98 ms (85.34%) |
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 443668 487320 494849 510165 514640 523061 542091 555411 561839 562763 582469 592784 598158 601886 612476 612578 620001 620250 622412 627567 632754 650937 659065 662020 667165 668105 668987 670032 674550 694930 695843 708399 709323 715573 723123 726295 726356 726385 727060 728457 728646 730225 730607 732605 733130 733151 734229 744400 747946 754161 755166 756947 758197 758426 761242 763068 764028 765036 765062 766493 767751 768363 769088 769338 769587 771445 771849 772168 772404 775518 777612 777992 779004 779048 779079 781408 781569 782150 782324 782326 782939 783432 783612 783823 785085 786030 786032 787150 787585 787889 788078 788091 788381 788840 789154 790159 791049 791491 791494 793456 793740 793878 795016 798521 800357 800614 800994 802863 804517 809964 810593 811504 817938 819449 819850 823655 825267 825510 826025 ] |
||||||||||||||||||||||||||||||
|
16.62 ms (8.76%) |
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 800614 787889 793456 793740 802863 761242 783432 795016 800357 767751 726356 727060 744400 765062 769338 726295 779079 788381 582469 650937 791049 825267 819850 825510 494849 542091 555411 708399 668105 632754 627567 777992 804517 786030 730225 754161 755166 766493 781324 781408 782326 787150 788091 756947 726385 733151 747946 728457 765036 772168 775518 779048 785085 809964 562763 598158 514640 817938 826025 561839 695843 667165 674550 779004 787585 811504 782150 791494 810593 734229 786032 788840 789154 768363 771849 612578 709323 777612 782939 790159 791491 793878 800994 662020 620001 601886 620250 732605 443668 823655 819449 487320 510165 523061 659065 668987 670032 694930 715573 723123 622412 592784 612476 783612 783823 798521 758426 764028 769088 772404 781569 782324 788078 730607 733130 758197 769587 771445 728646 763068 ] |
||||||||||||||||||||||||||||||
|
3.47 ms (1.83%) |
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 443668 487320 494849 510165 514640 523061 542091 555411 561839 562763 582469 592784 598158 601886 612476 612578 620001 620250 622412 627567 632754 650937 659065 662020 667165 668105 668987 670032 674550 694930 695843 708399 709323 715573 723123 726295 726356 726385 727060 728457 728646 730225 730607 732605 733130 733151 734229 744400 747946 754161 755166 756947 758197 758426 761242 763068 764028 765036 765062 766493 767751 768363 769088 769338 769587 771445 771849 772168 772404 775518 777612 777992 779004 779048 779079 781408 781569 782150 782324 782326 782939 783432 783612 783823 785085 786030 786032 787150 787585 787889 788078 788091 788381 788840 789154 790159 791049 791491 791494 793456 793740 793878 795016 798521 800357 800614 800994 802863 804517 809964 810593 811504 817938 819449 819850 823655 825267 825510 826025 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum face"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum in face"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum face"
]
|
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.