Query Metrics
7
Database Queries
7
Different statements
199.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.66 ms (89.15%) |
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 101841 191069 397063 398357 400071 400422 403042 403052 421623 425952 435830 463219 463324 465123 470820 472874 477262 479326 488299 521742 536102 539790 555734 571390 578353 581130 583297 583536 588221 592261 594111 605067 609072 610928 616137 618129 622465 634315 640149 644037 644072 644135 645643 649511 652519 662512 669281 673254 674202 677726 682223 686058 686824 689551 698797 699602 706475 706645 708762 709824 711337 716076 718636 720767 722437 722585 724372 724677 727633 727683 728284 733030 733227 736967 739016 740522 740902 744516 744889 746458 747384 748322 749137 754086 755584 761224 761847 763152 766140 770342 775537 779695 780485 783782 785731 786986 787934 788140 789899 795333 796332 796765 796929 797088 801677 802572 802870 805088 807932 809945 809987 810876 812132 813545 814084 817022 819901 819993 823777 824345 ] |
||||||||||||||||||||||||||||||
|
11.36 ms (5.70%) |
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 578353 673254 645643 644135 783782 789899 795333 787934 796929 746458 761224 779695 686058 397063 718636 801677 807932 796765 810876 727683 739016 733030 766140 706645 805088 400071 588221 463219 618129 819993 823777 470820 521742 686824 709824 616137 644072 749137 761847 644037 191069 740902 733227 727633 400422 814084 813545 817022 674202 720767 662512 571390 796332 809987 802572 763152 740522 744889 698797 780485 421623 819901 465123 583297 555734 689551 682223 722437 592261 610928 640149 605067 775537 788140 748322 785731 802870 724677 728284 754086 724372 770342 634315 699602 797088 812132 101841 472874 488299 824345 677726 706475 708762 594111 786986 736967 747384 398357 403042 435830 536102 539790 583536 581130 649511 669281 716076 722585 652519 711337 609072 744516 755584 622465 809945 403052 477262 425952 463324 479326 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (1.65%) |
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 101841 191069 397063 398357 400071 400422 403042 403052 421623 425952 435830 463219 463324 465123 470820 472874 477262 479326 488299 521742 536102 539790 555734 571390 578353 581130 583297 583536 588221 592261 594111 605067 609072 610928 616137 618129 622465 634315 640149 644037 644072 644135 645643 649511 652519 662512 669281 673254 674202 677726 682223 686058 686824 689551 698797 699602 706475 706645 708762 709824 711337 716076 718636 720767 722437 722585 724372 724677 727633 727683 728284 733030 733227 736967 739016 740522 740902 744516 744889 746458 747384 748322 749137 754086 755584 761224 761847 763152 766140 770342 775537 779695 780485 783782 785731 786986 787934 788140 789899 795333 796332 796765 796929 797088 801677 802572 802870 805088 807932 809945 809987 810876 812132 813545 814084 817022 819901 819993 823777 824345 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"little pussy"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"little pussy"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"little 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.