Query Metrics
7
Database Queries
7
Different statements
270.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
240.67 ms (89.04%) |
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 154374 315244 390684 398025 406176 415961 416571 441969 443092 444743 445968 448773 449992 451246 451316 458780 459731 465287 465651 467560 467568 467598 470403 470470 479684 480357 489676 493418 494481 494493 498915 502269 502885 510834 514994 522264 530124 530372 531217 534114 534257 535651 536604 543893 554889 555101 555599 557685 558190 568449 574362 577371 580114 580504 587307 595615 597111 598115 598675 600936 600943 600948 606558 606677 609888 614623 614975 615636 623154 633755 639791 641554 642029 643080 655010 666672 666736 666967 671479 673257 674043 674087 689508 699201 712580 713027 720074 723461 723660 728540 728567 728571 730329 735747 736022 737473 739113 739558 740250 742224 743455 744266 745918 746364 746515 750121 752610 752623 762222 762673 764280 772235 777039 796663 807142 809015 809847 810662 812553 822298 ] |
||||||||||||||||||||||||||||||
|
18.39 ms (6.81%) |
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 746515 746364 744266 764280 809015 459731 735747 315244 441969 416571 467568 467598 470403 451316 470470 494493 510834 558190 580114 666672 600943 750121 465651 467560 415961 498915 489676 522264 398025 445968 514994 530124 535651 555101 674087 723461 655010 689508 671479 712580 606558 606677 641554 597111 807142 772235 812553 728571 730329 739113 739558 752623 740250 390684 480357 458780 577371 448773 494481 614975 502885 444743 479684 598675 615636 443092 451246 493418 154374 406176 723660 822298 465287 449992 502269 531217 536604 534114 530372 534257 543893 557685 580504 554889 568449 574362 666736 699201 720074 666967 673257 674043 713027 555599 600948 587307 598115 639791 595615 600936 623154 633755 609888 614623 642029 643080 796663 810662 777039 809847 736022 737473 752610 762222 728567 762673 728540 742224 743455 745918 ] |
||||||||||||||||||||||||||||||
|
3.91 ms (1.45%) |
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 154374 315244 390684 398025 406176 415961 416571 441969 443092 444743 445968 448773 449992 451246 451316 458780 459731 465287 465651 467560 467568 467598 470403 470470 479684 480357 489676 493418 494481 494493 498915 502269 502885 510834 514994 522264 530124 530372 531217 534114 534257 535651 536604 543893 554889 555101 555599 557685 558190 568449 574362 577371 580114 580504 587307 595615 597111 598115 598675 600936 600943 600948 606558 606677 609888 614623 614975 615636 623154 633755 639791 641554 642029 643080 655010 666672 666736 666967 671479 673257 674043 674087 689508 699201 712580 713027 720074 723461 723660 728540 728567 728571 730329 735747 736022 737473 739113 739558 740250 742224 743455 744266 745918 746364 746515 750121 752610 752623 762222 762673 764280 772235 777039 796663 807142 809015 809847 810662 812553 822298 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo by cock"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.61%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд cock"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд cock"
]
|
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.