Query Metrics
7
Database Queries
7
Different statements
185.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.47 ms (85.35%) |
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 413134 416880 423697 423740 434763 435746 435795 438331 438715 440838 441938 442865 445204 446535 446577 446666 448172 449450 450326 450787 451108 451133 451333 452326 453061 454402 454869 455495 455620 455697 455979 456174 457026 458326 459656 459910 460093 463173 463313 463411 463966 465385 470891 471326 471328 472683 475232 475624 477607 477858 478060 485290 487975 488295 492312 494325 499529 500506 501205 501938 504320 504848 505796 507895 511216 511953 516230 516510 517143 520823 522905 523838 523937 525092 530303 537810 546720 551612 554228 555799 556609 558261 558606 560002 561344 564711 565936 573389 573453 576179 579390 579537 583072 585156 585703 588038 588414 591108 591932 592989 597432 601176 601331 603067 615645 621745 624537 624905 626329 632924 637172 688993 689004 705890 718455 720659 720922 732648 746774 799941 ] |
||||||||||||||||||||||||||||||
|
17.34 ms (9.34%) |
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 450326 454869 458326 504320 523937 523838 441938 435795 455495 450787 455620 455697 463313 478060 507895 511953 537810 530303 564711 573389 579537 718455 720659 591108 621745 588038 592989 732648 446666 475624 471326 477607 453061 463173 471328 442865 448172 460093 451333 463966 511216 689004 603067 585703 597432 637172 438715 413134 434763 456174 459910 463411 465385 446535 485290 505796 517143 573453 546720 579390 583072 560002 576179 705890 551612 556609 591932 632924 585156 624905 615645 624537 720922 470891 435746 499529 525092 522905 416880 423697 440838 449450 452326 455979 477858 451108 454402 494325 516510 472683 487975 558261 558606 561344 554228 555799 565936 688993 601331 626329 799941 746774 475232 446577 451133 457026 438331 445204 501205 520823 501938 504848 488295 492312 516230 423740 500506 601176 588414 459656 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.67%) |
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 413134 416880 423697 423740 434763 435746 435795 438331 438715 440838 441938 442865 445204 446535 446577 446666 448172 449450 450326 450787 451108 451133 451333 452326 453061 454402 454869 455495 455620 455697 455979 456174 457026 458326 459656 459910 460093 463173 463313 463411 463966 465385 470891 471326 471328 472683 475232 475624 477607 477858 478060 485290 487975 488295 492312 494325 499529 500506 501205 501938 504320 504848 505796 507895 511216 511953 516230 516510 517143 520823 522905 523838 523937 525092 530303 537810 546720 551612 554228 555799 556609 558261 558606 560002 561344 564711 565936 573389 573453 576179 579390 579537 583072 585156 585703 588038 588414 591108 591932 592989 597432 601176 601331 603067 615645 621745 624537 624905 626329 632924 637172 688993 689004 705890 718455 720659 720922 732648 746774 799941 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"watching домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"watching homemade"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.81%) |
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.