Query Metrics
7
Database Queries
7
Different statements
152.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.12 ms (83.87%) |
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 464727 539295 542726 544854 545355 547805 547815 550205 551912 554715 555055 555615 555619 556000 558264 566761 567496 570179 574398 576617 576652 577409 580903 581929 582277 592966 597873 599914 599915 600200 601579 613958 614330 618378 618902 619455 627804 631194 632618 632645 632663 632703 633491 633502 633716 634363 634774 634780 636463 637741 639774 639802 640361 640802 641644 641955 641956 647838 647875 647885 648825 651148 651188 666053 666863 666881 666883 667360 668137 680147 680159 684780 684789 693376 699185 699401 703735 704248 705351 707236 715444 718576 719649 725470 726624 727534 729187 729236 729253 730352 731022 733119 734342 734415 740265 744496 744568 744811 744832 749340 750299 755137 758259 766450 783357 787022 795924 795952 798755 800119 810089 812242 817107 819424 820150 824196 824896 825824 826321 827190 ] |
||||||||||||||||||||||||||||||
|
14.95 ms (9.78%) |
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 634780 639774 566761 539295 544854 555055 547805 647875 718576 547815 619455 749340 750299 798755 699401 744832 567496 703735 744811 641956 574398 556000 570179 576652 581929 668137 632703 597873 730352 555619 634363 734415 744496 740265 810089 545355 633502 825824 819424 820150 826321 795952 744568 634774 640361 550205 666881 647885 651188 680147 640802 600200 601579 639802 627804 637741 464727 817107 554715 580903 684780 693376 715444 592966 755137 727534 729236 726624 758259 812242 582277 734342 577409 704248 648825 666883 599915 599914 632618 632645 641644 824896 558264 576617 666053 667360 699185 555615 613958 614330 733119 783357 787022 729253 705351 551912 636463 647838 651148 666863 680159 641955 618378 633491 631194 632663 824196 827190 542726 684789 719649 707236 618902 800119 795924 731022 729187 766450 725470 633716 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (2.00%) |
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 464727 539295 542726 544854 545355 547805 547815 550205 551912 554715 555055 555615 555619 556000 558264 566761 567496 570179 574398 576617 576652 577409 580903 581929 582277 592966 597873 599914 599915 600200 601579 613958 614330 618378 618902 619455 627804 631194 632618 632645 632663 632703 633491 633502 633716 634363 634774 634780 636463 637741 639774 639802 640361 640802 641644 641955 641956 647838 647875 647885 648825 651148 651188 666053 666863 666881 666883 667360 668137 680147 680159 684780 684789 693376 699185 699401 703735 704248 705351 707236 715444 718576 719649 725470 726624 727534 729187 729236 729253 730352 731022 733119 734342 734415 740265 744496 744568 744811 744832 749340 750299 755137 758259 766450 783357 787022 795924 795952 798755 800119 810089 812242 817107 819424 820150 824196 824896 825824 826321 827190 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"piss pussy"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"писсинг pussy"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"писсинг pussy"
]
|
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.