Query Metrics
7
Database Queries
7
Different statements
170.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.68 ms (83.92%) |
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 235887 397421 446865 447972 448755 448837 448868 450549 452223 452345 452415 453220 453239 454055 454373 454387 454600 455083 456017 456410 457300 457563 458558 459259 459905 460148 460204 460550 460617 460682 461213 462359 463216 464670 464836 465472 467121 469097 471174 471337 473531 474778 474865 475467 475681 475690 476186 476715 477642 480212 480238 482479 483444 483470 485949 487060 488889 491516 502280 505073 506126 507166 508249 509599 510717 515535 515675 517039 521706 524272 525678 526250 526578 526961 527501 531626 548232 549250 550032 551923 554231 555977 556589 556861 558242 558736 559835 562256 563729 564052 570936 572765 574425 580638 580932 583374 585338 585694 588202 588828 590987 591985 594247 598484 599010 603018 604645 610454 623835 673612 694115 726879 733446 741701 741712 758236 758793 760468 787119 790882 ] |
||||||||||||||||||||||||||||||
|
16.70 ms (9.82%) |
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 474865 476186 477642 482479 483444 485949 487060 446865 447972 448837 450549 452223 452415 453220 456410 458558 459905 460204 460617 460682 463216 465472 471174 483470 448755 448868 452345 453239 454055 454373 454387 454600 455083 456017 457300 457563 459259 462359 464670 464836 467121 474778 476715 480238 488889 502280 517039 507166 508249 521706 525678 526961 527501 515535 515675 526250 505073 506126 509599 510717 524272 526578 531626 460148 460550 461213 469097 471337 473531 475467 475681 475690 480212 491516 549250 554231 558736 562256 564052 572765 550032 551923 556589 559835 574425 580932 548232 555977 558242 563729 580638 583374 673612 694115 556861 570936 590987 594247 603018 623835 588828 591985 599010 585694 604645 610454 585338 588202 598484 790882 760468 726879 733446 758236 758793 741712 741701 787119 235887 397421 ] |
||||||||||||||||||||||||||||||
|
4.03 ms (2.37%) |
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 235887 397421 446865 447972 448755 448837 448868 450549 452223 452345 452415 453220 453239 454055 454373 454387 454600 455083 456017 456410 457300 457563 458558 459259 459905 460148 460204 460550 460617 460682 461213 462359 463216 464670 464836 465472 467121 469097 471174 471337 473531 474778 474865 475467 475681 475690 476186 476715 477642 480212 480238 482479 483444 483470 485949 487060 488889 491516 502280 505073 506126 507166 508249 509599 510717 515535 515675 517039 521706 524272 525678 526250 526578 526961 527501 531626 548232 549250 550032 551923 554231 555977 556589 556861 558242 558736 559835 562256 563729 564052 570936 572765 574425 580638 580932 583374 585338 585694 588202 588828 590987 591985 594247 598484 599010 603018 604645 610454 623835 673612 694115 726879 733446 741701 741712 758236 758793 760468 787119 790882 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"naked boobs"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"голые boobs"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"голые boobs"
]
|
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.