Query Metrics
7
Database Queries
7
Different statements
148.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.19 ms (81.45%) |
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 395735 401757 402597 406724 420254 420853 420877 423516 427487 427544 432743 432745 440274 440414 440580 440749 440902 440939 441984 443166 451629 455745 457146 464800 464853 465540 468749 487987 492112 492222 499083 505725 513817 520790 537958 541755 552697 559996 560966 562225 564557 577678 581384 586853 593589 598623 599072 604221 610121 610434 610517 610522 610526 614880 620115 626688 627308 631117 633455 636951 639040 639279 647611 659324 665831 668083 668097 670084 674127 678903 685843 691170 692817 702165 707569 712393 713676 715593 717876 719225 719640 721249 721978 724048 727805 727882 731382 732579 732822 735005 736470 740009 748334 757715 758208 760214 761030 761531 772517 775813 776320 784288 786048 789437 790972 793075 793727 794381 795686 796183 796194 798675 800975 801290 807419 818835 820164 823359 824320 824868 ] |
||||||||||||||||||||||||||||||
|
16.96 ms (11.40%) |
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 790972 468749 440749 798675 659324 740009 692817 441984 727805 455745 627308 807419 395735 735005 732579 552697 715593 564557 610522 758208 727882 707569 820164 721978 719225 801290 784288 748334 757715 440580 581384 824320 499083 665831 685843 793075 796183 761531 796194 631117 717876 724048 761030 465540 464853 562225 401757 457146 427487 560966 610434 626688 712393 427544 440902 633455 760214 670084 487987 823359 402597 559996 795686 818835 674127 793727 423516 537958 599072 604221 505725 647611 719640 440414 702165 440939 492222 775813 732822 731382 432743 451629 577678 420254 440274 432745 721249 639040 776320 794381 736470 593589 824868 713676 586853 420853 691170 492112 668097 800975 541755 598623 610517 636951 789437 678903 406724 614880 464800 610526 420877 520790 513817 668083 610121 620115 786048 772517 639279 443166 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.95%) |
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 395735 401757 402597 406724 420254 420853 420877 423516 427487 427544 432743 432745 440274 440414 440580 440749 440902 440939 441984 443166 451629 455745 457146 464800 464853 465540 468749 487987 492112 492222 499083 505725 513817 520790 537958 541755 552697 559996 560966 562225 564557 577678 581384 586853 593589 598623 599072 604221 610121 610434 610517 610522 610526 614880 620115 626688 627308 631117 633455 636951 639040 639279 647611 659324 665831 668083 668097 670084 674127 678903 685843 691170 692817 702165 707569 712393 713676 715593 717876 719225 719640 721249 721978 724048 727805 727882 731382 732579 732822 735005 736470 740009 748334 757715 758208 760214 761030 761531 772517 775813 776320 784288 786048 789437 790972 793075 793727 794381 795686 796183 796194 798675 800975 801290 807419 818835 820164 823359 824320 824868 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real anal sex"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real анал секс"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real анал секс"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.16%) |
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.