Query Metrics
7
Database Queries
7
Different statements
404.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.88 ms (52.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step step mom"
]
|
||||||||||||||||||||||||||||||
|
165.54 ms (40.89%) |
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 370928 384015 397255 398564 398947 400179 402342 403031 411310 418520 420540 421132 421139 422807 429409 433070 438199 442426 450795 451880 454043 458719 460184 460188 476904 477067 486008 490031 490456 507115 513117 519836 521634 523256 525310 531997 532063 532207 533568 539611 544236 547912 549719 551154 557500 557815 559083 560410 561460 561465 561568 561587 563898 563931 569952 579761 580007 582269 586150 587685 589923 590533 592856 599368 602734 603743 603834 604561 612922 616199 639304 640172 664660 688100 690091 710310 710374 710575 710604 711354 714049 715662 721233 724295 725402 727190 728352 728472 739965 742321 746107 746663 757866 759898 760616 760875 763280 764185 769163 770006 771749 786455 788610 793547 797052 797950 800097 800926 803217 803685 806164 806741 807394 807452 807454 807515 815353 818465 820335 825102 ] |
||||||||||||||||||||||||||||||
|
18.62 ms (4.60%) |
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 513117 519836 531997 532207 539611 507115 525310 532063 544236 549719 559083 560410 561460 561465 561587 580007 547912 563931 569952 551154 557500 563898 710374 714049 688100 710575 711354 690091 710310 710604 721233 557815 592856 640172 604561 639304 590533 586150 589923 603834 616199 800097 797950 800926 803685 807394 807452 807515 746663 725402 728472 757866 769163 770006 724295 727190 728352 742321 759898 760875 764185 771749 739965 746107 760616 763280 612922 793547 797052 803217 806164 806741 807454 370928 397255 398564 398947 477067 384015 521634 400179 820335 490031 454043 476904 579761 561568 715662 664660 587685 788610 786455 402342 420540 438199 460188 418520 421132 460184 403031 451880 421139 433070 533568 490456 523256 429409 458719 582269 599368 603743 602734 411310 422807 442426 815353 818465 825102 450795 486008 ] |
||||||||||||||||||||||||||||||
|
3.25 ms (0.80%) |
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 370928 384015 397255 398564 398947 400179 402342 403031 411310 418520 420540 421132 421139 422807 429409 433070 438199 442426 450795 451880 454043 458719 460184 460188 476904 477067 486008 490031 490456 507115 513117 519836 521634 523256 525310 531997 532063 532207 533568 539611 544236 547912 549719 551154 557500 557815 559083 560410 561460 561465 561568 561587 563898 563931 569952 579761 580007 582269 586150 587685 589923 590533 592856 599368 602734 603743 603834 604561 612922 616199 639304 640172 664660 688100 690091 710310 710374 710575 710604 711354 714049 715662 721233 724295 725402 727190 728352 728472 739965 742321 746107 746663 757866 759898 760616 760875 763280 764185 769163 770006 771749 786455 788610 793547 797052 797950 800097 800926 803217 803685 806164 806741 807394 807452 807454 807515 815353 818465 820335 825102 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step step mom"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step step mom"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.