Query Metrics
7
Database Queries
7
Different statements
198.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.89 ms (86.44%) |
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 122817 236036 236472 348158 351650 366284 383832 402254 402518 406040 419545 426675 443002 443378 444223 444802 451547 451558 451578 453514 453595 454279 454350 458595 462155 462539 464317 464738 467628 470563 470590 470616 470672 471189 474494 476261 478461 478723 480387 481358 485960 488726 489042 491361 493342 496065 497575 499022 502002 502229 504446 505445 506420 508041 508517 512485 513303 520350 521619 523109 523952 523982 533851 539139 540286 543979 547959 549169 551195 552159 552212 552887 558999 562247 562251 566549 566584 566635 566637 569400 573776 573925 576069 576389 576393 584022 585089 585596 585671 590579 599332 600682 600887 613309 614611 625164 633079 633097 634505 651644 659347 661915 662556 671761 695661 699661 706480 713794 719452 738583 744933 749799 758501 763724 779146 788519 799813 800027 803252 814765 ] |
||||||||||||||||||||||||||||||
|
15.44 ms (7.76%) |
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 481358 566549 788519 800027 552887 499022 451578 426675 523982 462155 462539 662556 671761 633097 633079 576393 533851 573776 467628 562247 523109 480387 763724 504446 474494 470590 476261 590579 625164 566637 122817 513303 366284 614611 585671 699661 584022 659347 749799 402518 799813 719452 458595 552159 508041 351650 695661 585089 706480 539139 552212 488726 470563 454279 451547 236472 497575 444802 402254 454350 502229 478461 464738 585596 738583 779146 491361 758501 236036 496065 744933 543979 573925 406040 506420 493342 443002 443378 566635 348158 566584 470672 502002 508517 576069 558999 521619 419545 814765 713794 485960 600887 512485 599332 453514 453595 576389 651644 451558 562251 470616 540286 478723 634505 383832 464317 520350 471189 444223 523952 505445 661915 600682 613309 551195 803252 547959 569400 489042 549169 ] |
||||||||||||||||||||||||||||||
|
3.68 ms (1.85%) |
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 122817 236036 236472 348158 351650 366284 383832 402254 402518 406040 419545 426675 443002 443378 444223 444802 451547 451558 451578 453514 453595 454279 454350 458595 462155 462539 464317 464738 467628 470563 470590 470616 470672 471189 474494 476261 478461 478723 480387 481358 485960 488726 489042 491361 493342 496065 497575 499022 502002 502229 504446 505445 506420 508041 508517 512485 513303 520350 521619 523109 523952 523982 533851 539139 540286 543979 547959 549169 551195 552159 552212 552887 558999 562247 562251 566549 566584 566635 566637 569400 573776 573925 576069 576389 576393 584022 585089 585596 585671 590579 599332 600682 600887 613309 614611 625164 633079 633097 634505 651644 659347 661915 662556 671761 695661 699661 706480 713794 719452 738583 744933 749799 758501 763724 779146 788519 799813 800027 803252 814765 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс в бан"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"трах в бане"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс в бан"
]
|
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.