Query Metrics
7
Database Queries
7
Different statements
184.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.08 ms (84.56%) |
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 388690 396746 414341 414344 414357 414621 415936 416166 417344 417829 420203 425709 426417 441186 452018 462470 464168 468010 468628 474621 476753 478096 494620 499104 507696 508883 510198 510394 512509 513799 517788 518467 521576 522157 523206 523225 527428 530060 530784 530789 530791 530808 531097 531116 531135 531204 531230 531257 531259 532852 532960 532984 533773 533944 534627 536262 536359 536562 536618 536631 536645 536650 536653 536712 537114 537200 537660 537763 537771 537896 537903 537906 537908 537911 540404 544784 544812 584022 599961 600342 600352 617416 629963 632283 632649 633768 633773 633775 634118 634207 636303 637044 639706 639742 639762 640755 642006 642037 642061 644918 647322 647638 647954 649970 651147 666589 675019 676025 676107 677676 677801 678141 678159 678533 679029 679728 696203 708443 720260 745384 ] |
||||||||||||||||||||||||||||||
|
18.17 ms (9.85%) |
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 531230 531257 534627 536562 536618 537763 537771 537908 532960 531116 532852 536631 536650 537911 494620 527428 530789 532984 537200 537896 540404 478096 544784 544812 666589 679728 720260 676025 677801 678533 696203 647322 647638 651147 675019 676107 642061 639762 600352 636303 639706 640755 600342 634207 639742 617416 633768 708443 414621 425709 474621 417344 468628 518467 510394 507696 537906 629963 536359 677676 632649 523225 536645 536653 530784 531259 599961 745384 632283 633775 513799 499104 530808 647954 420203 441186 414341 414344 414357 415936 644918 462470 476753 468010 512509 522157 523206 530791 536262 537903 508883 464168 584022 649970 678141 679029 678159 637044 634118 426417 536712 521576 642006 642037 633773 396746 388690 416166 417829 452018 533944 510198 537660 530060 531135 531204 517788 531097 533773 537114 ] |
||||||||||||||||||||||||||||||
|
3.63 ms (1.96%) |
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 388690 396746 414341 414344 414357 414621 415936 416166 417344 417829 420203 425709 426417 441186 452018 462470 464168 468010 468628 474621 476753 478096 494620 499104 507696 508883 510198 510394 512509 513799 517788 518467 521576 522157 523206 523225 527428 530060 530784 530789 530791 530808 531097 531116 531135 531204 531230 531257 531259 532852 532960 532984 533773 533944 534627 536262 536359 536562 536618 536631 536645 536650 536653 536712 537114 537200 537660 537763 537771 537896 537903 537906 537908 537911 540404 544784 544812 584022 599961 600342 600352 617416 629963 632283 632649 633768 633773 633775 634118 634207 636303 637044 639706 639742 639762 640755 642006 642037 642061 644918 647322 647638 647954 649970 651147 666589 675019 676025 676107 677676 677801 678141 678159 678533 679029 679728 696203 708443 720260 745384 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc extreme anal"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc хардкор анал"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc хардкор анал"
]
|
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.