Query Metrics
7
Database Queries
7
Different statements
187.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.60 ms (85.29%) |
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 397741 413963 415303 416694 418121 418219 418738 421152 424362 426220 427311 427396 434378 434693 439504 444544 447697 450579 450969 451852 452115 452753 454009 457063 460860 467908 472230 475649 478963 479239 486874 492732 505061 505328 507737 511379 512994 516652 516661 521831 522094 522383 522658 524355 527085 531908 535279 545477 552567 553994 558200 558560 565767 571498 586375 590102 600481 605392 608152 613158 615915 624834 624942 625462 626443 630764 631947 634810 639823 642060 651584 669860 672402 676168 677838 708678 711990 714881 717550 724153 725188 726725 727395 728930 729252 735885 736294 741294 744158 753199 755515 756413 756479 757438 757512 765695 766258 768843 770271 775598 783933 790065 790941 798910 800214 800764 802736 804170 804470 806046 806454 807936 808614 808857 809677 810081 810853 815171 815243 815687 ] |
||||||||||||||||||||||||||||||
|
16.07 ms (8.59%) |
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 677838 421152 808857 507737 545477 753199 634810 809677 524355 505061 757512 452753 505328 624834 454009 522094 444544 516652 397741 815243 815171 522658 669860 711990 651584 672402 676168 708678 553994 571498 625462 608152 626443 586375 605392 613158 800214 775598 810081 810853 725188 726725 727395 766258 790065 798910 802736 729252 736294 757438 735885 765695 768843 714881 783933 790941 800764 804170 804470 806454 426220 434693 416694 460860 447697 486874 522383 531908 475649 552567 631947 624942 642060 615915 590102 478963 424362 434378 457063 418219 439504 472230 558560 558200 415303 418738 427396 418121 451852 467908 450969 717550 600481 741294 807936 512994 492732 630764 808614 724153 744158 755515 511379 413963 479239 565767 452115 521831 516661 535279 639823 728930 756413 770271 756479 427311 450579 527085 815687 806046 ] |
||||||||||||||||||||||||||||||
|
3.54 ms (1.89%) |
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 397741 413963 415303 416694 418121 418219 418738 421152 424362 426220 427311 427396 434378 434693 439504 444544 447697 450579 450969 451852 452115 452753 454009 457063 460860 467908 472230 475649 478963 479239 486874 492732 505061 505328 507737 511379 512994 516652 516661 521831 522094 522383 522658 524355 527085 531908 535279 545477 552567 553994 558200 558560 565767 571498 586375 590102 600481 605392 608152 613158 615915 624834 624942 625462 626443 630764 631947 634810 639823 642060 651584 669860 672402 676168 677838 708678 711990 714881 717550 724153 725188 726725 727395 728930 729252 735885 736294 741294 744158 753199 755515 756413 756479 757438 757512 765695 766258 768843 770271 775598 783933 790065 790941 798910 800214 800764 802736 804170 804470 806046 806454 807936 808614 808857 809677 810081 810853 815171 815243 815687 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"squirt ass"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сквирт оргазм жоп"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сквирт оргазм жоп"
]
|
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.