Query Metrics
7
Database Queries
7
Different statements
180.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.83 ms (87.79%) |
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 312447 383154 383224 385906 389888 392802 393122 393502 401830 410699 413737 420257 432017 434135 441037 441897 446170 446594 449066 449442 449862 450830 451719 452530 455345 457257 457487 458070 459918 460173 464870 465557 465977 466462 466612 467785 468225 470396 472064 472356 472842 475845 477042 478239 480561 483962 485753 491696 492615 493119 495203 495726 497324 497714 503041 505171 507104 507204 510377 515606 520192 520924 522413 525925 526880 527507 527516 527541 527546 528679 529003 534084 534341 536725 537783 541802 543196 543530 544591 547200 549278 550237 550427 550589 550607 552013 552022 554432 555280 556843 562567 563168 563204 563210 563454 564283 564640 565333 565352 566073 568131 568483 569135 569803 570225 570371 571623 572396 573284 573423 575865 576462 578079 580027 580990 584088 584821 657279 684335 825545 ] |
||||||||||||||||||||||||||||||
|
10.91 ms (6.03%) |
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 465977 466462 470396 472356 478239 468225 495203 497714 525925 526880 491696 492615 385906 383154 383224 393502 393122 392802 312447 389888 401830 413737 420257 441037 410699 432017 434135 441897 825545 446170 449862 451719 452530 455345 457257 457487 458070 460173 464870 466612 472842 477042 493119 449066 450830 459918 467785 472064 475845 485753 446594 449442 480561 483962 495726 510377 515606 520924 534341 503041 507204 529003 534084 536725 497324 505171 507104 520192 527507 527516 527541 537783 522413 527546 528679 465557 550237 550607 556843 563168 568131 570225 570371 573423 576462 580027 584821 541802 543530 549278 550589 554432 555280 562567 564283 564640 568483 569803 573284 578079 580990 584088 543196 544591 547200 550427 552013 552022 563204 563210 563454 565333 565352 566073 569135 571623 572396 575865 657279 684335 ] |
||||||||||||||||||||||||||||||
|
3.30 ms (1.83%) |
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 312447 383154 383224 385906 389888 392802 393122 393502 401830 410699 413737 420257 432017 434135 441037 441897 446170 446594 449066 449442 449862 450830 451719 452530 455345 457257 457487 458070 459918 460173 464870 465557 465977 466462 466612 467785 468225 470396 472064 472356 472842 475845 477042 478239 480561 483962 485753 491696 492615 493119 495203 495726 497324 497714 503041 505171 507104 507204 510377 515606 520192 520924 522413 525925 526880 527507 527516 527541 527546 528679 529003 534084 534341 536725 537783 541802 543196 543530 544591 547200 549278 550237 550427 550589 550607 552013 552022 554432 555280 556843 562567 563168 563204 563210 563454 564283 564640 565333 565352 566073 568131 568483 569135 569803 570225 570371 571623 572396 573284 573423 575865 576462 578079 580027 580990 584088 584821 657279 684335 825545 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"с под юбки"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"юбк"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.