Query Metrics
7
Database Queries
7
Different statements
167.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.44 ms (83.24%) |
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 388365 390939 394258 397284 417102 417793 418138 419078 421211 423335 423721 435795 437368 438852 441938 442865 446666 447071 448172 449379 450326 450787 451333 453061 454869 455495 455620 455697 456954 458326 458787 459972 460093 460166 460447 463173 463313 463966 471326 471328 473522 475463 475599 475624 477607 478060 481213 492227 501512 504320 507895 509137 510051 510701 511216 511953 514655 516613 517676 523666 523838 523937 527832 530303 537810 541128 543351 554222 564488 564711 567528 572250 572268 573267 573389 578705 579128 579537 579631 585276 585703 585752 588038 588609 589296 590917 591108 592989 598840 600653 600859 603067 604677 605498 605820 606765 612387 614773 617122 618332 621745 622257 628289 633934 635723 650276 665822 671426 686596 689004 702007 718455 719388 720659 726549 729678 730975 732648 753752 775487 ] |
||||||||||||||||||||||||||||||
|
18.11 ms (10.81%) |
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 447071 460166 460447 481213 492227 501512 510701 510051 527832 419078 394258 421211 516613 650276 665822 702007 671426 578705 579128 600859 617122 618332 606765 590917 600653 588609 605820 628289 514655 598840 390939 541128 388365 423335 417102 417793 423721 456954 449379 458787 459972 475463 509137 517676 473522 543351 572250 579631 564488 573267 686596 719388 567528 572268 585276 604677 585752 589296 612387 622257 633934 729678 730975 726549 753752 614773 775487 438852 475599 437368 418138 450326 454869 458326 504320 523937 523838 397284 441938 435795 455495 450787 455620 455697 463313 478060 507895 511953 537810 530303 554222 564711 573389 579537 718455 720659 591108 621745 635723 588038 592989 732648 446666 475624 471326 477607 453061 463173 471328 442865 448172 460093 451333 463966 511216 523666 605498 689004 603067 585703 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.86%) |
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 388365 390939 394258 397284 417102 417793 418138 419078 421211 423335 423721 435795 437368 438852 441938 442865 446666 447071 448172 449379 450326 450787 451333 453061 454869 455495 455620 455697 456954 458326 458787 459972 460093 460166 460447 463173 463313 463966 471326 471328 473522 475463 475599 475624 477607 478060 481213 492227 501512 504320 507895 509137 510051 510701 511216 511953 514655 516613 517676 523666 523838 523937 527832 530303 537810 541128 543351 554222 564488 564711 567528 572250 572268 573267 573389 578705 579128 579537 579631 585276 585703 585752 588038 588609 589296 590917 591108 592989 598840 600653 600859 603067 604677 605498 605820 606765 612387 614773 617122 618332 621745 622257 628289 633934 635723 650276 665822 671426 686596 689004 702007 718455 719388 720659 726549 729678 730975 732648 753752 775487 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск watching"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur watching"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск watching"
]
|
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.