Query Metrics
7
Database Queries
7
Different statements
159.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.37 ms (82.37%) |
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 187847 205520 383556 384560 386589 395547 395913 398508 403314 409803 410231 410520 411433 413473 418727 422565 422599 422600 422709 423345 428882 435398 439526 445345 446266 446272 447490 453995 464506 465788 467240 467972 471515 472179 479023 481847 484144 486354 491354 491503 495403 509324 520629 534797 535622 549320 550229 552027 559328 564681 568053 568987 575194 582179 583781 587735 592479 606704 609746 611103 612861 621766 622274 625450 625698 646851 665027 683745 694114 696325 697022 709369 712832 716076 718734 720816 720927 721744 725293 725352 725638 731817 732303 734613 735796 736400 743178 745012 747652 748136 750498 751664 755823 760958 772532 772883 775819 779860 781697 782268 784618 785929 789215 790168 790369 790988 792722 793636 798329 802109 804530 804763 807324 807547 807920 807998 813914 815275 819564 819586 ] |
||||||||||||||||||||||||||||||
|
16.35 ms (10.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 784618 804530 736400 745012 748136 709369 534797 465788 559328 439526 386589 410231 445345 583781 568987 411433 789215 611103 509324 446266 418727 486354 187847 750498 622274 731817 592479 398508 609746 606704 582179 725352 435398 467972 484144 790168 807998 819586 549320 564681 712832 721744 779860 798329 790369 807547 725638 575194 621766 409803 587735 205520 720927 802109 760958 718734 410520 775819 813914 819564 520629 683745 720816 625698 790988 735796 755823 734613 751664 732303 747652 793636 422565 422599 422600 384560 479023 781697 467240 403314 413473 743178 395547 422709 453995 471515 472179 481847 395913 491354 491503 696325 815275 550229 383556 552027 665027 716076 694114 807920 725293 772532 792722 804763 807324 568053 535622 782268 772883 785929 447490 625450 495403 423345 446272 697022 612861 428882 464506 646851 ] |
||||||||||||||||||||||||||||||
|
3.61 ms (2.26%) |
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 187847 205520 383556 384560 386589 395547 395913 398508 403314 409803 410231 410520 411433 413473 418727 422565 422599 422600 422709 423345 428882 435398 439526 445345 446266 446272 447490 453995 464506 465788 467240 467972 471515 472179 479023 481847 484144 486354 491354 491503 495403 509324 520629 534797 535622 549320 550229 552027 559328 564681 568053 568987 575194 582179 583781 587735 592479 606704 609746 611103 612861 621766 622274 625450 625698 646851 665027 683745 694114 696325 697022 709369 712832 716076 718734 720816 720927 721744 725293 725352 725638 731817 732303 734613 735796 736400 743178 745012 747652 748136 750498 751664 755823 760958 772532 772883 775819 779860 781697 782268 784618 785929 789215 790168 790369 790988 792722 793636 798329 802109 804530 804763 807324 807547 807920 807998 813914 815275 819564 819586 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young girl stockings"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young девушк чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young девушк чулк нижн бел"
]
|
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.