Query Metrics
7
Database Queries
7
Different statements
222.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
194.92 ms (87.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 326017 327638 365875 381917 382444 384030 388878 389798 391106 391114 392028 394329 396024 396171 400497 400811 407791 408179 409390 415636 415797 417875 419552 422339 434251 446293 447962 450220 452015 455378 455428 456960 461989 462943 465771 482029 488224 494642 495369 497005 497441 498939 500576 503985 505622 506079 510573 511605 511787 511789 512577 512739 517282 519653 520359 520698 521407 522770 523170 532138 537006 543306 546631 549534 549669 551960 552340 554985 555582 555593 556684 557327 558160 558461 561401 562341 563016 564398 565774 566107 566880 567405 567418 567419 567884 569023 571138 572882 579811 580214 580866 584639 590501 590975 590977 591011 591028 591059 591061 591218 591452 591468 591485 591494 591519 591536 591566 591735 599720 604999 609197 610112 621687 622722 631750 636249 645939 656672 660457 691221 ] |
||||||||||||||||||||||||||||||
|
16.42 ms (7.36%) |
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 555593 591519 591536 591735 631750 590977 591011 591485 591494 604999 391106 465771 417875 511605 551960 580866 434251 452015 622722 365875 388878 549534 571138 656672 384030 381917 389798 396024 497005 562341 455378 495369 512577 494642 511787 510573 519653 537006 565774 567418 645939 591028 591566 590501 591452 591468 488224 506079 523170 500576 512739 517282 520359 522770 503985 532138 543306 558160 584639 555582 563016 569023 572882 599720 610112 394329 327638 382444 396171 407791 415636 456960 566107 392028 409390 462943 419552 455428 450220 400811 554985 557327 552340 566880 579811 546631 660457 590975 591059 621687 636249 591218 391114 564398 497441 567884 498939 415797 561401 567405 691221 400497 408179 447962 446293 511789 558461 422339 326017 461989 482029 505622 520698 521407 549669 556684 567419 580214 591061 609197 ] |
||||||||||||||||||||||||||||||
|
3.85 ms (1.73%) |
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 326017 327638 365875 381917 382444 384030 388878 389798 391106 391114 392028 394329 396024 396171 400497 400811 407791 408179 409390 415636 415797 417875 419552 422339 434251 446293 447962 450220 452015 455378 455428 456960 461989 462943 465771 482029 488224 494642 495369 497005 497441 498939 500576 503985 505622 506079 510573 511605 511787 511789 512577 512739 517282 519653 520359 520698 521407 522770 523170 532138 537006 543306 546631 549534 549669 551960 552340 554985 555582 555593 556684 557327 558160 558461 561401 562341 563016 564398 565774 566107 566880 567405 567418 567419 567884 569023 571138 572882 579811 580214 580866 584639 590501 590975 590977 591011 591028 591059 591061 591218 591452 591468 591485 591494 591519 591536 591566 591735 599720 604999 609197 610112 621687 622722 631750 636249 645939 656672 660457 691221 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"на кухня"
]
|
||||||||||||||||||||||||||||||
|
2.16 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на кухн"
]
|
||||||||||||||||||||||||||||||
|
1.55 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.