Query Metrics
7
Database Queries
7
Different statements
450.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.42 ms (47.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 417940 424227 445363 457169 458103 459558 461466 463166 463962 469921 476387 476819 477534 481308 482096 542934 543720 544368 546053 548654 548684 550404 551250 552627 558022 558273 560452 560619 560853 561316 562314 563803 564417 565107 565279 565912 566962 567393 568601 569453 569684 569784 569786 570055 570056 570059 570065 574504 574912 575210 575458 575473 575726 576021 576058 576352 576377 579279 579480 587297 595863 596650 596991 597518 598431 598614 598675 599095 600016 600066 604227 605304 617632 617660 633811 637520 653496 657363 659392 684541 684543 685718 692859 696218 704010 714447 714473 716027 720063 720800 720823 720825 721298 721325 722277 722751 722809 722846 722851 725112 725409 730893 733862 741539 749266 758180 758496 759329 775784 775788 787309 797462 800373 804373 807506 807514 807518 810701 810848 811669 ] |
||||||||||||||||||||||||||||||
|
207.99 ms (46.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian teens young"
]
|
||||||||||||||||||||||||||||||
|
18.13 ms (4.02%) |
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 551250 558022 558273 560853 565107 567393 568601 570055 570065 574912 575458 576021 579480 542934 550404 552627 561316 562314 569784 569786 570059 576058 576377 543720 544368 560452 563803 565279 566962 569453 575210 575726 684543 692859 696218 714447 720063 653496 659392 684541 720800 720823 722751 722809 657363 685718 714473 716027 720825 722277 546053 548654 548684 560619 564417 565912 569684 570056 574504 575473 576352 579279 587297 596650 598675 604227 598431 599095 600066 605304 633811 637520 595863 597518 617632 596991 598614 600016 617660 775784 775788 807518 810701 804373 807514 811669 725409 758496 787309 797462 800373 810848 725112 759329 730893 741539 749266 758180 733862 704010 721298 721325 722846 722851 807506 417940 457169 477534 481308 482096 424227 459558 461466 463166 463962 445363 458103 469921 476387 476819 ] |
||||||||||||||||||||||||||||||
|
4.00 ms (0.89%) |
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 417940 424227 445363 457169 458103 459558 461466 463166 463962 469921 476387 476819 477534 481308 482096 542934 543720 544368 546053 548654 548684 550404 551250 552627 558022 558273 560452 560619 560853 561316 562314 563803 564417 565107 565279 565912 566962 567393 568601 569453 569684 569784 569786 570055 570056 570059 570065 574504 574912 575210 575458 575473 575726 576021 576058 576352 576377 579279 579480 587297 595863 596650 596991 597518 598431 598614 598675 599095 600016 600066 604227 605304 617632 617660 633811 637520 653496 657363 659392 684541 684543 685718 692859 696218 704010 714447 714473 716027 720063 720800 720823 720825 721298 721325 722277 722751 722809 722846 722851 725112 725409 730893 733862 741539 749266 758180 758496 759329 775784 775788 787309 797462 800373 804373 807506 807514 807518 810701 810848 811669 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск teens young"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск teens young"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.36%) |
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.