Query Metrics
7
Database Queries
7
Different statements
188.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.37 ms (88.84%) |
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 24243 33562 149612 386190 387672 443553 443583 460724 484466 495682 510045 516611 535819 536547 540603 547025 551022 557144 558187 564893 566070 567805 599774 602196 607616 619482 622370 624463 625878 626379 629362 647645 653004 663497 663857 664969 666556 673984 681597 684018 684065 695980 697249 705385 707935 707962 710887 714148 715279 716112 716308 717092 719913 719939 721603 729091 731068 732106 734126 734180 738168 738324 738576 746318 761245 763030 766101 767140 770119 771345 771363 775755 776630 779327 781783 781929 783776 786448 789204 794615 794930 795488 796251 796424 796549 797624 799631 807339 808038 808642 809273 809288 810063 814022 814109 814979 815398 816769 817406 817488 817691 817962 818454 818506 818836 819262 819545 819609 820055 820203 820727 821079 821606 823289 823415 823693 824148 825829 826306 827033 ] |
||||||||||||||||||||||||||||||
|
11.82 ms (6.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 729091 705385 734180 386190 716112 149612 821606 814109 820055 818506 664969 599774 721603 796549 809273 810063 495682 818454 684065 719913 763030 738168 767140 717092 776630 734126 771363 775755 816769 817962 823693 815398 460724 551022 622370 624463 808642 808038 789204 770119 732106 761245 714148 796251 809288 24243 629362 567805 516611 558187 766101 794930 818836 817406 817488 817691 823289 719939 779327 795488 796424 799631 771345 781929 783776 794615 814022 387672 825829 820203 819545 731068 797624 540603 443583 710887 666556 626379 738324 547025 443553 819609 663857 33562 484466 557144 707935 602196 625878 807339 786448 746318 738576 510045 681597 619482 781783 819262 826306 814979 823415 827033 824148 820727 821079 536547 535819 564893 566070 695980 697249 715279 647645 653004 684018 716308 663497 673984 707962 607616 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.12%) |
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 24243 33562 149612 386190 387672 443553 443583 460724 484466 495682 510045 516611 535819 536547 540603 547025 551022 557144 558187 564893 566070 567805 599774 602196 607616 619482 622370 624463 625878 626379 629362 647645 653004 663497 663857 664969 666556 673984 681597 684018 684065 695980 697249 705385 707935 707962 710887 714148 715279 716112 716308 717092 719913 719939 721603 729091 731068 732106 734126 734180 738168 738324 738576 746318 761245 763030 766101 767140 770119 771345 771363 775755 776630 779327 781783 781929 783776 786448 789204 794615 794930 795488 796251 796424 796549 797624 799631 807339 808038 808642 809273 809288 810063 814022 814109 814979 815398 816769 817406 817488 817691 817962 818454 818506 818836 819262 819545 819609 820055 820203 820727 821079 821606 823289 823415 823693 824148 825829 826306 827033 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"saggy tits blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"saggy сиськ минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"saggy сиськ минет оральн секс"
]
|
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.