Query Metrics
7
Database Queries
7
Different statements
152.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.98 ms (80.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 91532 386416 393049 395405 396214 397200 417799 422512 424652 431432 439213 446133 451671 452623 456524 457367 462921 470241 471310 473101 476180 477401 478515 482958 483159 483194 483387 484431 485348 490740 494379 497894 508884 510115 512170 512174 513119 516613 517925 519729 520652 521743 522367 524529 526767 530610 533668 538463 539518 542126 542417 543264 543786 543851 546805 548575 552068 556042 564139 566199 570851 584016 591178 593212 597216 598624 598633 611547 613929 621424 623855 626739 629339 630729 632015 633340 633514 637413 639104 641778 646927 650357 661608 662806 663899 666734 680137 689964 692378 716719 716739 720471 720635 722511 724324 726205 728786 735086 737099 745187 747235 747530 748949 750115 761169 767120 778096 782165 797643 801027 805567 809168 811085 815733 817117 817156 817860 818812 819584 827871 ] |
||||||||||||||||||||||||||||||
|
18.34 ms (12.05%) |
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 485348 521743 490740 91532 526767 689964 778096 747530 805567 767120 745187 633340 722511 446133 817156 817860 548575 737099 811085 566199 538463 462921 476180 692378 546805 632015 748949 451671 508884 513119 641778 761169 386416 519729 716719 483194 422512 819584 817117 482958 494379 512174 720471 556042 613929 591178 797643 396214 827871 497894 663899 611547 626739 782165 747235 735086 720635 424652 478515 457367 483387 512170 539518 564139 646927 552068 750115 417799 473101 477401 395405 397200 431432 456524 510115 818812 570851 621424 724324 801027 598624 484431 542417 543786 543851 543264 650357 662806 680137 716739 661608 666734 584016 623855 593212 809168 633514 470241 726205 597216 637413 530610 517925 393049 483159 516613 452623 439213 815733 471310 520652 522367 524529 533668 542126 598633 630729 639104 728786 629339 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (2.07%) |
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 91532 386416 393049 395405 396214 397200 417799 422512 424652 431432 439213 446133 451671 452623 456524 457367 462921 470241 471310 473101 476180 477401 478515 482958 483159 483194 483387 484431 485348 490740 494379 497894 508884 510115 512170 512174 513119 516613 517925 519729 520652 521743 522367 524529 526767 530610 533668 538463 539518 542126 542417 543264 543786 543851 546805 548575 552068 556042 564139 566199 570851 584016 591178 593212 597216 598624 598633 611547 613929 621424 623855 626739 629339 630729 632015 633340 633514 637413 639104 641778 646927 650357 661608 662806 663899 666734 680137 689964 692378 716719 716739 720471 720635 722511 724324 726205 728786 735086 737099 745187 747235 747530 748949 750115 761169 767120 778096 782165 797643 801027 805567 809168 811085 815733 817117 817156 817860 818812 819584 827871 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"humiliation blowjob"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"доминирован минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"доминирован минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.17%) |
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.