Query Metrics
7
Database Queries
7
Different statements
144.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.15 ms (82.63%) |
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 390849 398213 402016 408316 414236 414254 446216 456327 456912 458537 461534 461541 470333 471904 490019 510658 511879 512152 512255 515136 528943 530981 531017 533436 534280 538638 540283 541948 545610 546390 546681 546740 548722 554360 554959 557283 558855 558857 559181 561826 573635 573698 573874 573880 575515 575766 578367 585012 595194 601540 601646 601857 605135 606548 611431 624850 629069 646934 650949 655732 658009 659270 659585 660307 661259 664235 665326 680499 695476 699485 713420 713481 721796 721837 722161 726381 726744 735597 735672 736001 739524 742214 744324 745052 746308 751395 752494 752573 752902 753994 754313 755324 755922 757857 759368 760615 768901 777150 777153 779354 779373 783767 789513 791344 799276 804036 812211 813724 815494 815981 816462 816858 816866 818240 818310 822671 822694 825929 828501 ] |
||||||||||||||||||||||||||||||
|
14.25 ms (9.88%) |
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 534280 561826 559181 515136 799276 816866 818310 528943 471904 658009 659585 777153 753994 751395 699485 791344 390849 414254 818240 822671 815494 816462 664235 713420 606548 789513 804036 739524 735597 726381 408316 786797 755922 816858 828501 546390 713481 722161 650949 655732 665326 629069 601646 601540 611431 783767 757857 752902 745052 755324 759368 402016 585012 815981 822694 446216 538638 511879 541948 554360 558857 548722 558855 573698 575515 578367 546681 573635 680499 721796 661259 659270 660307 573874 573880 575766 595194 601857 624850 742214 726744 744324 760615 721837 456912 458537 461534 461541 456327 470333 510658 490019 512255 512152 779354 813724 530981 531017 533436 540283 554959 557283 646934 695476 546740 605135 777150 779373 812211 735672 736001 746308 754313 752494 768901 752573 414236 398213 545610 825929 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.93%) |
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 390849 398213 402016 408316 414236 414254 446216 456327 456912 458537 461534 461541 470333 471904 490019 510658 511879 512152 512255 515136 528943 530981 531017 533436 534280 538638 540283 541948 545610 546390 546681 546740 548722 554360 554959 557283 558855 558857 559181 561826 573635 573698 573874 573880 575515 575766 578367 585012 595194 601540 601646 601857 605135 606548 611431 624850 629069 646934 650949 655732 658009 659270 659585 660307 661259 664235 665326 680499 695476 699485 713420 713481 721796 721837 722161 726381 726744 735597 735672 736001 739524 742214 744324 745052 746308 751395 752494 752573 752902 753994 754313 755324 755922 757857 759368 760615 768901 777150 777153 779354 779373 783767 789513 791344 799276 804036 812211 813724 815494 815981 816462 816858 816866 818240 818310 822671 822694 825929 828501 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teens girl"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teens девушк"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teens девушк"
]
|
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.