Query Metrics
7
Database Queries
7
Different statements
152.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.69 ms (82.93%) |
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 201639 202134 384220 405043 423846 425762 441877 456787 456983 458894 458904 459546 459993 461631 462257 464125 469636 471472 474141 474810 475040 476877 479950 481441 485367 486644 487889 488974 489786 492697 493057 501466 504328 510364 513693 515263 515271 515282 516832 522216 523088 525735 525806 528868 530194 533991 546767 550555 550776 552332 553328 556393 559864 560999 564200 565103 566760 568398 571375 574671 575013 580365 581136 584101 593248 593270 593288 593314 593316 593330 593346 593354 593379 593381 593391 593396 593400 593404 593405 593418 593440 595842 602227 605915 606668 614499 619412 619678 622149 628308 635980 649516 668997 674330 675533 680468 683660 686877 687544 687588 688342 691510 698680 705518 708518 711006 712886 722420 742034 759883 759896 771364 775916 776442 788266 795538 801147 807757 817841 820126 ] |
||||||||||||||||||||||||||||||
|
16.58 ms (10.85%) |
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 489786 469636 510364 516832 513693 530194 533991 515282 488974 550555 580365 571375 575013 691510 722420 675533 705518 708518 560999 593270 593314 593316 605915 593354 593391 593396 593405 593440 606668 622149 628308 593248 593330 593346 593381 593400 593404 593418 595842 614499 619678 635980 593379 619412 795538 801147 775916 788266 759896 807757 742034 759883 771364 602227 711006 776442 201639 423846 456983 458904 459993 462257 479950 384220 459546 528868 504328 485367 515271 522216 487889 525735 202134 405043 425762 441877 817841 820126 474141 486644 493057 461631 476877 492697 456787 458894 471472 474810 501466 525806 515263 523088 464125 475040 481441 556393 559864 574671 581136 552332 553328 566760 568398 584101 546767 565103 674330 680468 687544 712886 668997 683660 698680 649516 686877 687588 688342 550776 564200 593288 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (2.03%) |
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 201639 202134 384220 405043 423846 425762 441877 456787 456983 458894 458904 459546 459993 461631 462257 464125 469636 471472 474141 474810 475040 476877 479950 481441 485367 486644 487889 488974 489786 492697 493057 501466 504328 510364 513693 515263 515271 515282 516832 522216 523088 525735 525806 528868 530194 533991 546767 550555 550776 552332 553328 556393 559864 560999 564200 565103 566760 568398 571375 574671 575013 580365 581136 584101 593248 593270 593288 593314 593316 593330 593346 593354 593379 593381 593391 593396 593400 593404 593405 593418 593440 595842 602227 605915 606668 614499 619412 619678 622149 628308 635980 649516 668997 674330 675533 680468 683660 686877 687544 687588 688342 691510 698680 705518 708518 711006 712886 722420 742034 759883 759896 771364 775916 776442 788266 795538 801147 807757 817841 820126 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"nurse 2009"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"врачих"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.90%) |
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.