Query Metrics
7
Database Queries
7
Different statements
190.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.72 ms (87.48%) |
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 67464 165669 188655 317820 382950 384200 386323 388212 389067 396278 403589 404054 408539 410132 413254 415554 420808 423063 428450 429276 431664 445472 448547 448859 454827 454857 456730 468553 468719 475448 476153 488379 490139 495155 512204 512207 512217 512218 514341 525103 540186 540189 550723 550727 550771 550991 551005 551978 552897 554094 556403 558357 560215 563880 566067 567825 568553 571824 572048 572727 573473 574603 575899 586639 589860 590919 590944 596752 599116 600544 601154 605418 622645 623512 641452 653415 654451 668950 673094 673144 683608 693219 698283 703229 712158 718309 722803 729065 737370 741935 742142 743018 743436 747055 748685 750448 755341 757130 758601 761580 762110 763322 765679 775979 784609 786472 792337 793630 808886 809737 811755 816360 817300 818211 818299 820780 822720 823515 823636 825750 ] |
||||||||||||||||||||||||||||||
|
15.20 ms (7.98%) |
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 165669 403589 763322 550771 404054 698283 540189 389067 747055 742142 673144 825750 423063 784609 703229 558357 188655 388212 512204 765679 673094 693219 762110 525103 554094 722803 786472 758601 67464 775979 600544 668950 420808 817300 623512 384200 317820 386323 729065 568553 574603 757130 750448 551978 793630 589860 572727 755341 514341 743436 475448 683608 641452 476153 552897 792337 741935 550727 654451 454857 408539 761580 556403 512217 382950 748685 601154 445472 429276 823636 818211 823515 743018 550723 396278 605418 495155 818299 816360 575899 718309 809737 551005 550991 596752 737370 808886 590944 571824 410132 822720 563880 468719 431664 413254 622645 454827 712158 653415 599116 820780 590919 488379 468553 415554 448859 567825 566067 428450 540186 586639 573473 512218 448547 456730 560215 490139 572048 811755 512207 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.29%) |
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 67464 165669 188655 317820 382950 384200 386323 388212 389067 396278 403589 404054 408539 410132 413254 415554 420808 423063 428450 429276 431664 445472 448547 448859 454827 454857 456730 468553 468719 475448 476153 488379 490139 495155 512204 512207 512217 512218 514341 525103 540186 540189 550723 550727 550771 550991 551005 551978 552897 554094 556403 558357 560215 563880 566067 567825 568553 571824 572048 572727 573473 574603 575899 586639 589860 590919 590944 596752 599116 600544 601154 605418 622645 623512 641452 653415 654451 668950 673094 673144 683608 693219 698283 703229 712158 718309 722803 729065 737370 741935 742142 743018 743436 747055 748685 750448 755341 757130 758601 761580 762110 763322 765679 775979 784609 786472 792337 793630 808886 809737 811755 816360 817300 818211 818299 820780 822720 823515 823636 825750 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian blowjob hot"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк минет оральн секс hot"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.33 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"азиатк минет оральн секс hot"
]
|
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.