Query Metrics
7
Database Queries
7
Different statements
151.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.36 ms (79.36%) |
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 411344 414081 415004 415388 415883 417965 418101 418215 419694 419860 424791 425037 429541 441489 444168 448863 448864 457764 460001 462428 467867 468054 469263 469434 469537 473778 475804 476088 479826 480194 482237 485129 489318 492242 497878 502868 503183 507189 511520 512830 513657 519316 527755 530846 531403 534301 534625 536613 540186 541919 544829 546465 550379 553111 556050 558680 559377 561107 565252 570179 570764 571697 583734 590344 591959 592702 597839 598642 599664 605309 606225 609926 617129 621675 624909 628398 633083 634561 639060 641996 644941 646776 654636 661268 661568 696202 704910 712886 714530 733589 737197 744169 748741 748997 751222 761294 761543 770444 777057 780603 782772 782775 785287 792341 797065 797771 798443 801287 801880 802832 806021 807923 809512 810995 815031 815299 816555 817115 818156 818181 ] |
||||||||||||||||||||||||||||||
|
20.66 ms (13.62%) |
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 815031 816555 457764 497878 544829 550379 571697 661568 553111 802832 770444 797771 807923 761294 633083 797065 534625 628398 411344 634561 785287 468054 530846 556050 609926 414081 818156 469434 570179 546465 624909 415004 448863 415883 744169 817115 644941 815299 818181 583734 485129 507189 503183 531403 536613 460001 482237 492242 565252 558680 654636 712886 704910 621675 605309 777057 806021 780603 737197 810995 801880 462428 469263 473778 441489 444168 418215 489318 513657 751222 661268 561107 527755 541919 646776 748741 415388 479826 419860 480194 591959 639060 641996 467867 418101 429541 417965 419694 448864 469537 519316 534301 540186 570764 559377 696202 714530 592702 599664 606225 617129 590344 597839 598642 801287 809512 798443 733589 761543 476088 424791 425037 475804 511520 502868 512830 792341 782772 782775 748997 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (2.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лиза сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
2.28 ms (1.51%) |
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 411344 414081 415004 415388 415883 417965 418101 418215 419694 419860 424791 425037 429541 441489 444168 448863 448864 457764 460001 462428 467867 468054 469263 469434 469537 473778 475804 476088 479826 480194 482237 485129 489318 492242 497878 502868 503183 507189 511520 512830 513657 519316 527755 530846 531403 534301 534625 536613 540186 541919 544829 546465 550379 553111 556050 558680 559377 561107 565252 570179 570764 571697 583734 590344 591959 592702 597839 598642 599664 605309 606225 609926 617129 621675 624909 628398 633083 634561 639060 641996 644941 646776 654636 661268 661568 696202 704910 712886 714530 733589 737197 744169 748741 748997 751222 761294 761543 770444 777057 780603 782772 782775 785287 792341 797065 797771 798443 801287 801880 802832 806021 807923 809512 810995 815031 815299 816555 817115 818156 818181 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"licking squirt"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (1.00%) |
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.