Query Metrics
7
Database Queries
7
Different statements
157.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.69 ms (85.72%) |
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 345456 382206 395554 404474 409878 414708 418946 442201 442604 446138 452350 452948 454044 454974 457995 461045 464355 476697 510035 511429 515403 569029 587566 588632 593045 593216 593301 597682 600964 601105 602210 602332 604896 604942 606831 607670 610181 614424 615057 618763 629797 634842 636738 637430 638426 639791 641940 653179 658118 661657 662931 668778 669224 670201 670214 672791 695292 696192 698458 702063 712415 713036 715292 717060 718015 721045 723991 726844 727480 736623 737526 737535 738107 741547 744467 745324 746627 746819 747107 747258 752944 755164 755338 755408 756281 756460 759711 759776 765478 771700 774769 775786 776724 781950 784641 784947 784951 785669 786147 787289 788983 789745 791057 792574 797752 798313 799598 801955 802758 802833 803170 803347 806179 806757 806984 808650 809270 810960 812557 813231 ] |
||||||||||||||||||||||||||||||
|
13.42 ms (8.54%) |
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 569029 658118 672791 695292 712415 715292 653179 661657 662931 668778 669224 670214 698458 717060 721045 702063 718015 587566 588632 602210 636738 597682 600964 601105 607670 610181 618763 593216 593301 629797 637430 641940 785669 791057 799598 802758 806984 813231 776724 784951 789745 803347 746819 755164 765478 784641 798313 801955 812557 726844 736623 737535 744467 745324 752944 756460 723991 738107 755408 737526 759711 759776 741547 747107 756281 771700 614424 615057 638426 774769 775786 781950 784947 786147 788983 792574 797752 802833 803170 806179 806757 809270 382206 395554 345456 404474 442201 414708 418946 409878 446138 454974 476697 452350 452948 454044 457995 461045 464355 511429 515403 510035 713036 670201 696192 593045 602332 604896 604942 634842 639791 606831 808650 746627 810960 727480 747258 755338 787289 442604 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.31%) |
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 345456 382206 395554 404474 409878 414708 418946 442201 442604 446138 452350 452948 454044 454974 457995 461045 464355 476697 510035 511429 515403 569029 587566 588632 593045 593216 593301 597682 600964 601105 602210 602332 604896 604942 606831 607670 610181 614424 615057 618763 629797 634842 636738 637430 638426 639791 641940 653179 658118 661657 662931 668778 669224 670201 670214 672791 695292 696192 698458 702063 712415 713036 715292 717060 718015 721045 723991 726844 727480 736623 737526 737535 738107 741547 744467 745324 746627 746819 747107 747258 752944 755164 755338 755408 756281 756460 759711 759776 765478 771700 774769 775786 776724 781950 784641 784947 784951 785669 786147 787289 788983 789745 791057 792574 797752 798313 799598 801955 802758 802833 803170 803347 806179 806757 806984 808650 809270 810960 812557 813231 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf boobs oil"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf boobs масл"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf boobs масл"
]
|
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.