Query Metrics
7
Database Queries
7
Different statements
186.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.67 ms (85.96%) |
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 145624 400884 411625 413792 434025 442651 457074 468327 493909 496714 500032 513758 518482 527104 527910 529813 532616 536114 538289 544873 554990 559156 559423 577814 579260 587151 588390 604927 607963 616094 618985 641435 641812 650150 658986 660383 661968 662097 665964 666028 666485 671559 672791 678837 680578 692756 700217 704591 710268 714294 714706 715289 717621 736691 738510 739482 740905 746106 748648 749830 751435 752415 752460 753183 756388 760158 762184 767853 770108 773306 774108 774215 776542 777935 780417 783323 784522 787337 788531 789183 790442 792586 794701 800689 800692 802352 802575 802578 805864 806817 807884 810096 811319 812551 814287 816718 817627 818960 819245 820048 822768 823996 824196 824530 824533 824633 824733 825329 825341 825397 825430 826499 826508 827009 827284 827439 827538 827629 827652 827654 ] |
||||||||||||||||||||||||||||||
|
16.98 ms (9.08%) |
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 776542 792586 774108 717621 780417 807884 457074 756388 577814 825329 827284 824733 825430 827654 827652 666485 714706 710268 604927 789183 800692 774215 770108 802578 527104 527910 824196 826508 822768 827439 827538 817627 816718 536114 532616 538289 468327 544873 559156 579260 559423 662097 671559 678837 660383 665964 554990 587151 588390 641812 618985 641435 787337 790442 794701 800689 802352 810096 777935 783323 784522 788531 811319 752460 760158 806817 812551 736691 767853 738510 748648 773306 739482 746106 749830 752415 740905 753183 762184 802575 805864 413792 442651 518482 715289 751435 616094 607963 513758 496714 493909 145624 400884 434025 411625 823996 826499 825341 827629 818960 820048 824530 824533 814287 819245 824633 827009 825397 529813 500032 650150 658986 666028 672791 692756 704591 714294 661968 680578 700217 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.38%) |
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 145624 400884 411625 413792 434025 442651 457074 468327 493909 496714 500032 513758 518482 527104 527910 529813 532616 536114 538289 544873 554990 559156 559423 577814 579260 587151 588390 604927 607963 616094 618985 641435 641812 650150 658986 660383 661968 662097 665964 666028 666485 671559 672791 678837 680578 692756 700217 704591 710268 714294 714706 715289 717621 736691 738510 739482 740905 746106 748648 749830 751435 752415 752460 753183 756388 760158 762184 767853 770108 773306 774108 774215 776542 777935 780417 783323 784522 787337 788531 789183 790442 792586 794701 800689 800692 802352 802575 802578 805864 806817 807884 810096 811319 812551 814287 816718 817627 818960 819245 820048 822768 823996 824196 824530 824533 824633 824733 825329 825341 825397 825430 826499 826508 827009 827284 827439 827538 827629 827652 827654 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big pussy solo"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие pussy соло"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.79%) |
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.