Query Metrics
7
Database Queries
7
Different statements
191.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.37 ms (86.76%) |
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 16831 21626 25788 27593 28872 75969 149538 185264 191361 194661 207540 317866 358879 382252 382544 383333 386430 387130 389218 390455 390530 390827 391070 395182 396980 397465 403378 426037 434430 439405 457902 460362 465169 469959 501680 506363 507739 508566 510250 513382 520983 525315 527842 529971 533173 535961 537142 540248 540426 543427 547147 547326 547346 551333 551497 553653 554434 562549 571785 575334 577254 584158 587335 595110 598768 617397 624046 636328 640314 641391 643434 644684 651665 663307 668488 670821 673017 680519 680541 680543 687118 693719 698353 717456 726135 729869 732132 759694 763395 766470 768058 771634 787311 803613 808187 810384 811871 817292 817764 819920 823799 823850 824726 824751 826049 826178 826336 827884 828089 828268 828372 828399 828413 828513 828633 828818 828827 828852 ] |
||||||||||||||||||||||||||||||
|
14.24 ms (7.42%) |
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 527842 617397 717456 562549 624046 803613 149538 25788 16831 397465 824751 824726 828399 828268 828852 828372 828827 537142 663307 668488 577254 644684 811871 768058 382544 207540 75969 426037 826336 817292 826049 823799 824210 828818 827843 535961 651665 687118 547326 643434 641391 763395 766470 28872 358879 317866 390827 533173 551497 680519 595110 810384 759694 389218 391070 390455 390530 396980 403378 819920 469959 457902 465169 540248 501680 506363 508566 529971 507739 540426 553653 554434 571785 584158 670821 640314 636328 587335 787311 434430 383333 387130 395182 439405 460362 510250 525315 513382 520983 27593 817764 823850 826178 828089 827884 828413 828633 828513 547147 547346 543427 551333 673017 693719 808187 729869 732132 771634 726135 698353 185264 21626 575334 680541 680543 598768 382252 191361 386430 194661 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.68%) |
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 16831 21626 25788 27593 28872 75969 149538 185264 191361 194661 207540 317866 358879 382252 382544 383333 386430 387130 389218 390455 390530 390827 391070 395182 396980 397465 403378 426037 434430 439405 457902 460362 465169 469959 501680 506363 507739 508566 510250 513382 520983 525315 527842 529971 533173 535961 537142 540248 540426 543427 547147 547326 547346 551333 551497 553653 554434 562549 571785 575334 577254 584158 587335 595110 598768 617397 624046 636328 640314 641391 643434 644684 651665 663307 668488 670821 673017 680519 680541 680543 687118 693719 698353 717456 726135 729869 732132 759694 763395 766470 768058 771634 787311 803613 808187 810384 811871 817292 817764 819920 823799 823850 824726 824751 826049 826178 826336 827884 828089 828268 828372 828399 828413 828513 828633 828818 828827 828852 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boobs riding"
]
|
||||||||||||||||||||||||||||||
|
2.25 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"boobs riding"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"boobs riding"
]
|
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.