Query Metrics
7
Database Queries
7
Different statements
167.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.55 ms (84.92%) |
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 31503 358481 359075 359102 385632 387496 389629 391156 391913 392031 392672 395891 395942 397219 397223 397647 398345 409935 439472 453096 460761 466020 466374 467550 470201 470959 471887 476363 478020 484393 488362 493105 493122 493587 496854 506516 518729 519152 528522 546883 549639 554492 560430 561757 563413 570169 576649 582586 587805 590345 620241 666028 666153 672913 672919 697618 714818 716487 718563 724719 726756 726862 727843 728506 729884 730352 734706 736196 739173 741147 742597 744210 744906 746106 747949 748379 750878 755776 757241 758429 765662 772740 774332 779178 780614 781771 782284 788877 789305 789363 794701 797252 797254 800710 801096 802798 804130 804216 804217 807189 817796 817815 817870 818402 818812 818971 819009 819011 819646 819754 819823 820115 823357 823457 824367 824806 825318 826589 826661 826827 ] |
||||||||||||||||||||||||||||||
|
15.95 ms (9.50%) |
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 358481 392031 392672 467550 476363 359102 391913 395891 409935 460761 470959 484393 31503 387496 397223 818971 819646 817815 819009 471887 546883 716487 672913 718563 561757 620241 587805 788877 794701 802798 779178 780614 782284 804216 741147 748379 755776 757241 772740 781771 789305 789363 800710 801096 807189 724719 726756 726862 727843 758429 739173 765662 774332 736196 744210 746106 747949 750878 742597 744906 697618 714818 797252 797254 804217 359075 389629 397219 398345 385632 819754 819823 823457 672919 729884 804130 734706 728506 493122 453096 563413 560430 730352 466020 470201 488362 391156 478020 493105 506516 493587 549639 570169 576649 590345 439472 466374 496854 528522 395942 397647 817870 819011 820115 823357 824367 824806 826661 826589 818812 826827 825318 817796 818402 518729 519152 554492 582586 666028 666153 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.61%) |
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 31503 358481 359075 359102 385632 387496 389629 391156 391913 392031 392672 395891 395942 397219 397223 397647 398345 409935 439472 453096 460761 466020 466374 467550 470201 470959 471887 476363 478020 484393 488362 493105 493122 493587 496854 506516 518729 519152 528522 546883 549639 554492 560430 561757 563413 570169 576649 582586 587805 590345 620241 666028 666153 672913 672919 697618 714818 716487 718563 724719 726756 726862 727843 728506 729884 730352 734706 736196 739173 741147 742597 744210 744906 746106 747949 748379 750878 755776 757241 758429 765662 772740 774332 779178 780614 781771 782284 788877 789305 789363 794701 797252 797254 800710 801096 802798 804130 804216 804217 807189 817796 817815 817870 818402 818812 818971 819009 819011 819646 819754 819823 820115 823357 823457 824367 824806 825318 826589 826661 826827 ] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature pussy"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature pussy"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature 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.