Query Metrics
7
Database Queries
7
Different statements
172.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.78 ms (85.20%) |
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 8005 110884 192943 213604 306045 341608 385590 389553 389875 393050 394713 395141 395411 396018 396273 396336 396745 399410 399727 405242 412506 414609 415718 419109 423676 425035 429040 432887 437227 438971 442015 445278 449342 453612 453790 453898 458588 459574 459586 460076 461020 461796 461918 462169 462281 464600 467376 468753 468794 469423 470395 470863 471385 472383 472720 473064 475343 475352 478917 482782 483900 483944 487436 492440 493987 497575 500085 509264 511126 514700 515742 521957 524768 527467 538211 539515 544830 545014 545598 546039 547082 549865 551175 552143 564071 564652 565432 565479 567359 567755 570258 571268 574541 593858 594231 595741 601691 622123 622582 650842 652122 668141 681140 689565 691616 694660 699802 703391 715526 725096 731684 737125 747017 750062 761123 773761 775811 809510 810189 814809 ] |
||||||||||||||||||||||||||||||
|
15.48 ms (8.98%) |
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 703391 8005 509264 438971 527467 437227 514700 478917 432887 459574 483900 594231 396745 552143 694660 622582 773761 306045 442015 461020 538211 487436 192943 396018 445278 482782 471385 689565 545598 809510 731684 747017 715526 415718 394713 405242 461796 521957 468794 461918 539515 493987 567359 593858 393050 396273 462281 468753 472383 467376 110884 564071 571268 650842 652122 681140 691616 545014 564652 595741 737125 725096 761123 699802 475343 213604 429040 425035 449342 459586 460076 453790 458588 469423 547082 549865 668141 565479 601691 453898 462169 470863 472720 464600 511126 497575 524768 515742 395141 341608 396336 453612 565432 570258 551175 567755 574541 544830 622123 810189 750062 775811 399410 423676 385590 395411 389553 389875 399727 414609 419109 412506 814809 492440 470395 473064 483944 500085 475352 546039 ] |
||||||||||||||||||||||||||||||
|
2.98 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 8005 110884 192943 213604 306045 341608 385590 389553 389875 393050 394713 395141 395411 396018 396273 396336 396745 399410 399727 405242 412506 414609 415718 419109 423676 425035 429040 432887 437227 438971 442015 445278 449342 453612 453790 453898 458588 459574 459586 460076 461020 461796 461918 462169 462281 464600 467376 468753 468794 469423 470395 470863 471385 472383 472720 473064 475343 475352 478917 482782 483900 483944 487436 492440 493987 497575 500085 509264 511126 514700 515742 521957 524768 527467 538211 539515 544830 545014 545598 546039 547082 549865 551175 552143 564071 564652 565432 565479 567359 567755 570258 571268 574541 593858 594231 595741 601691 622123 622582 650842 652122 668141 681140 689565 691616 694660 699802 703391 715526 725096 731684 737125 747017 750062 761123 773761 775811 809510 810189 814809 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"с двумя членами"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"двум член"
]
|
||||||||||||||||||||||||||||||
|
1.42 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.