Query Metrics
7
Database Queries
7
Different statements
249.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
221.27 ms (88.74%) |
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 8497 146317 385112 387359 391491 394235 395889 397707 398619 400023 401468 401644 403463 411560 413794 415805 417955 421413 425554 426325 428049 428683 428922 430289 430369 432376 432419 432945 433059 433452 434195 440347 443149 443297 444348 444562 444661 444961 445326 447275 453662 454685 454697 455939 457300 460410 460614 460633 461547 462021 463161 464296 465972 466024 466113 466405 466588 469609 473800 473914 476837 477337 477608 478220 480300 480501 484279 485852 488614 489026 489256 490209 491767 494862 496357 498518 502177 504733 504960 508714 511312 513339 513795 514385 514472 515582 516258 517765 526243 527046 527719 528572 539356 545711 547751 549760 549765 550351 555834 558011 558825 559033 560473 560833 562148 565022 565086 565960 567038 570069 571521 572370 572761 573395 573958 574905 576005 576366 581468 811931 ] |
||||||||||||||||||||||||||||||
|
17.07 ms (6.84%) |
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 504960 516258 539356 413794 469609 559033 573958 394235 8497 527046 811931 401644 440347 491767 457300 513795 549760 555834 558011 558825 571521 573395 545711 567038 426325 433452 443297 466024 432376 444348 428049 460410 498518 504733 511312 514385 514472 528572 488614 489026 502177 526243 485852 490209 496357 517765 527719 395889 391491 397707 430289 430369 415805 428683 432945 445326 447275 455939 460614 480300 484279 454685 460633 466588 473800 489256 494862 508714 464296 547751 549765 572370 560473 565022 570069 572761 574905 576005 576366 560833 565086 565960 550351 562148 581468 400023 428922 433059 443149 473914 401468 444661 444961 462021 463161 476837 477337 387359 403463 421413 425554 453662 466405 477608 146317 385112 398619 411560 417955 432419 434195 444562 454697 461547 480501 465972 466113 478220 513339 515582 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.18%) |
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 8497 146317 385112 387359 391491 394235 395889 397707 398619 400023 401468 401644 403463 411560 413794 415805 417955 421413 425554 426325 428049 428683 428922 430289 430369 432376 432419 432945 433059 433452 434195 440347 443149 443297 444348 444562 444661 444961 445326 447275 453662 454685 454697 455939 457300 460410 460614 460633 461547 462021 463161 464296 465972 466024 466113 466405 466588 469609 473800 473914 476837 477337 477608 478220 480300 480501 484279 485852 488614 489026 489256 490209 491767 494862 496357 498518 502177 504733 504960 508714 511312 513339 513795 514385 514472 515582 516258 517765 526243 527046 527719 528572 539356 545711 547751 549760 549765 550351 555834 558011 558825 559033 560473 560833 562148 565022 565086 565960 567038 570069 571521 572370 572761 573395 573958 574905 576005 576366 581468 811931 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"на диван"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на дива"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.69%) |
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.