Query Metrics
7
Database Queries
7
Different statements
423.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.34 ms (49.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс step mom"
]
|
||||||||||||||||||||||||||||||
|
187.50 ms (44.29%) |
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 392277 394552 397174 397255 398564 398947 400143 405437 407154 409374 412288 425998 430835 432834 432837 437583 442783 443921 452335 455281 456736 459850 476909 477067 478107 481794 481874 486023 507115 508450 510287 513117 515022 515802 518858 519836 523256 532063 533959 534221 534845 535010 547912 549719 551069 551154 553278 557815 559008 559083 561465 561587 562600 563157 563443 563454 569952 571508 579371 589923 590812 601089 601234 609238 612922 622668 622710 663274 674249 687940 688646 697221 698312 710310 710575 710604 718560 724295 725402 725578 726627 727190 728259 728352 728447 728472 746107 748892 757866 759898 760549 760616 763280 764137 764185 768163 769163 770006 771749 784304 787827 791182 793547 799936 800097 803217 803363 803685 804620 804675 806164 807394 807407 807452 807454 807515 818465 820096 823263 824434 ] |
||||||||||||||||||||||||||||||
|
18.12 ms (4.28%) |
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 760616 397174 405437 443921 452335 515022 561465 551154 710575 803685 807515 728352 759898 806164 398947 534221 697221 687940 590812 791182 768163 803363 728259 726627 764137 760549 787827 508450 523256 394552 392277 409374 820096 507115 532063 549719 561587 547912 710604 557815 800097 807394 725402 728472 757866 769163 770006 724295 746107 612922 803217 601234 784304 400143 515802 412288 481794 432837 442783 476909 807407 430835 510287 698312 609238 535010 486023 824434 823263 459850 513117 519836 559083 569952 710310 589923 807452 727190 764185 771749 763280 793547 807454 397255 398564 477067 425998 622668 534845 799936 432834 571508 622710 407154 518858 748892 674249 456736 579371 559008 563443 478107 481874 437583 533959 818465 663274 804675 553278 562600 563454 688646 718560 563157 601089 804620 728447 725578 551069 455281 ] |
||||||||||||||||||||||||||||||
|
3.44 ms (0.81%) |
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 392277 394552 397174 397255 398564 398947 400143 405437 407154 409374 412288 425998 430835 432834 432837 437583 442783 443921 452335 455281 456736 459850 476909 477067 478107 481794 481874 486023 507115 508450 510287 513117 515022 515802 518858 519836 523256 532063 533959 534221 534845 535010 547912 549719 551069 551154 553278 557815 559008 559083 561465 561587 562600 563157 563443 563454 569952 571508 579371 589923 590812 601089 601234 609238 612922 622668 622710 663274 674249 687940 688646 697221 698312 710310 710575 710604 718560 724295 725402 725578 726627 727190 728259 728352 728447 728472 746107 748892 757866 759898 760549 760616 763280 764137 764185 768163 769163 770006 771749 784304 787827 791182 793547 799936 800097 803217 803363 803685 804620 804675 806164 807394 807407 807452 807454 807515 818465 820096 823263 824434 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck step mom"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс step mom"
]
|
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.