Query Metrics
7
Database Queries
7
Different statements
148.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.29 ms (82.42%) |
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 12193 187986 188561 223663 231522 358849 381818 382791 386037 386630 387490 388318 391087 391277 392208 392632 393856 397113 397445 397876 397881 398932 400645 400826 400835 400849 401203 402131 407551 415843 421891 423505 433359 437471 439628 441774 443626 444208 450243 451209 452182 453686 457452 457464 457895 471336 471422 475224 477418 478365 478374 480062 481445 485638 486820 489849 492631 493755 495157 495852 499331 509151 516028 517426 523390 524134 528501 530359 543123 543994 545868 549568 549779 549822 549828 549840 549848 554235 555992 561033 563641 566917 571103 573728 579336 584771 591130 591820 599502 604332 698154 702031 710282 714561 724999 725188 727863 731259 731345 733530 739923 739927 742716 742749 746682 750303 757240 761025 761188 765644 767058 784299 788518 791602 794914 796714 797348 800906 802195 811702 ] |
||||||||||||||||||||||||||||||
|
16.21 ms (10.92%) |
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 727863 731259 757240 739927 746682 750303 765644 724999 742716 742749 761025 761188 788518 802195 392208 388318 358849 386630 188561 12193 530359 223663 393856 397113 441774 471422 499331 545868 796714 784299 794914 797348 725188 767058 733530 714561 231522 397445 400645 451209 386037 382791 187986 392632 381818 443626 450243 489849 457895 477418 481445 492631 524134 528501 495852 523390 495157 517426 471336 486820 543994 543123 566917 702031 561033 604332 591820 599502 811702 791602 731345 739923 698154 710282 800906 387490 391087 398932 400835 423505 421891 444208 509151 493755 516028 397881 401203 407551 415843 437471 485638 554235 555992 579336 549568 571103 573728 584771 549779 549822 549828 549840 549848 563641 591130 400826 402131 475224 478365 478374 480062 391277 439628 397876 400849 433359 453686 457452 457464 452182 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.98%) |
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 12193 187986 188561 223663 231522 358849 381818 382791 386037 386630 387490 388318 391087 391277 392208 392632 393856 397113 397445 397876 397881 398932 400645 400826 400835 400849 401203 402131 407551 415843 421891 423505 433359 437471 439628 441774 443626 444208 450243 451209 452182 453686 457452 457464 457895 471336 471422 475224 477418 478365 478374 480062 481445 485638 486820 489849 492631 493755 495157 495852 499331 509151 516028 517426 523390 524134 528501 530359 543123 543994 545868 549568 549779 549822 549828 549840 549848 554235 555992 561033 563641 566917 571103 573728 579336 584771 591130 591820 599502 604332 698154 702031 710282 714561 724999 725188 727863 731259 731345 733530 739923 739927 742716 742749 746682 750303 757240 761025 761188 765644 767058 784299 788518 791602 794914 796714 797348 800906 802195 811702 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"doggy mature"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак mature"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рак mature"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.