Query Metrics
7
Database Queries
7
Different statements
202.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.42 ms (88.06%) |
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 398164 398613 400000 402337 404318 412362 421043 429449 437314 452057 455281 456475 458440 462510 463710 469507 475263 477883 479348 487431 489148 493455 494323 498927 510657 510673 513677 514748 517010 517240 517874 519929 519936 520485 521027 530347 532079 534040 534155 540724 541882 541913 542939 543330 543825 544234 547518 549368 549382 551203 557231 557343 559020 560574 561086 563219 563882 565314 565454 566710 568539 569967 570171 570175 570410 570657 571666 572602 573757 574840 576644 578067 580269 581292 582135 584797 586980 590426 603014 639443 644664 651893 651957 652898 652939 652966 677061 684159 688335 688642 698045 698282 700454 704579 715836 717696 721068 722882 723926 728172 741467 756877 766413 767996 769456 773432 775455 776716 780963 784005 789659 789740 791189 800959 802849 808060 815437 816973 818338 824316 ] |
||||||||||||||||||||||||||||||
|
13.46 ms (6.64%) |
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 570410 541882 544234 570175 580269 651957 652939 652966 688335 721068 651893 677061 700454 722882 652898 717696 563882 568539 570657 571666 572602 574840 590426 603014 780963 789659 775455 802849 723926 756877 766413 789740 728172 741467 767996 773432 769456 639443 644664 698045 698282 704579 776716 784005 791189 800959 402337 456475 398613 479348 458440 462510 540724 494323 510673 487431 493455 455281 520485 532079 469507 684159 688642 715836 561086 578067 581292 586980 808060 437314 475263 412362 452057 421043 514748 519929 513677 517240 517874 517010 519936 521027 569967 429449 404318 398164 400000 815437 816973 818338 824316 463710 477883 489148 498927 510657 530347 534155 534040 541913 543330 543825 547518 549368 549382 551203 557231 557343 559020 560574 563219 565314 565454 566710 570171 573757 576644 582135 584797 542939 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.53%) |
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 398164 398613 400000 402337 404318 412362 421043 429449 437314 452057 455281 456475 458440 462510 463710 469507 475263 477883 479348 487431 489148 493455 494323 498927 510657 510673 513677 514748 517010 517240 517874 519929 519936 520485 521027 530347 532079 534040 534155 540724 541882 541913 542939 543330 543825 544234 547518 549368 549382 551203 557231 557343 559020 560574 561086 563219 563882 565314 565454 566710 568539 569967 570171 570175 570410 570657 571666 572602 573757 574840 576644 578067 580269 581292 582135 584797 586980 590426 603014 639443 644664 651893 651957 652898 652939 652966 677061 684159 688335 688642 698045 698282 700454 704579 715836 717696 721068 722882 723926 728172 741467 756877 766413 767996 769456 773432 775455 776716 780963 784005 789659 789740 791189 800959 802849 808060 815437 816973 818338 824316 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sleeping beauty"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"спящ beauty"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спящ beauty"
]
|
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.