Query Metrics
7
Database Queries
7
Different statements
203.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.84 ms (86.34%) |
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 263259 365056 389891 396303 398691 401135 402628 404422 408164 414968 415220 416002 418133 421489 423706 424332 427115 432270 435131 439156 441080 441101 441233 441615 445066 447220 448327 449070 449319 451146 451246 451251 452720 453332 454531 456024 456161 458538 460323 466564 468061 469540 473416 475450 477762 478055 483704 497665 497675 500320 502776 502780 504474 508430 510198 512939 516656 517745 525679 530026 530761 531862 533272 533707 536470 540868 541757 541760 543652 564563 569922 599833 599864 599961 599966 604061 604226 604387 605725 605742 613860 619802 624845 628363 632708 634157 643027 647895 647905 647936 648220 648235 666880 666902 666904 695882 703930 714028 725626 728465 738503 743706 756491 757393 760507 777046 782041 784848 787919 791363 795395 797178 800884 806022 806943 810299 811221 812495 815847 823368 ] |
||||||||||||||||||||||||||||||
|
17.83 ms (8.75%) |
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 502780 599864 811221 795395 619802 541760 714028 757393 605725 647895 531862 725626 441101 643027 456024 738503 475450 445066 441615 451146 449070 456161 396303 530761 451251 441080 473416 666904 466564 500320 777046 604061 497675 756491 703930 760507 408164 823368 806943 634157 787919 441233 533272 424332 604387 533707 800884 401135 447220 806022 812495 599961 460323 613860 398691 404422 421489 512939 402628 389891 414968 415220 416002 263259 423706 458538 647905 647936 510198 435131 497665 469540 648220 648235 666902 432270 517745 530026 628363 540868 536470 782041 468061 427115 784848 605742 449319 516656 728465 483704 632708 502776 541757 478055 543652 525679 695882 439156 453332 418133 448327 815847 599833 743706 454531 569922 477762 508430 666880 810299 797178 365056 791363 624845 564563 604226 452720 451246 504474 599966 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.42%) |
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 263259 365056 389891 396303 398691 401135 402628 404422 408164 414968 415220 416002 418133 421489 423706 424332 427115 432270 435131 439156 441080 441101 441233 441615 445066 447220 448327 449070 449319 451146 451246 451251 452720 453332 454531 456024 456161 458538 460323 466564 468061 469540 473416 475450 477762 478055 483704 497665 497675 500320 502776 502780 504474 508430 510198 512939 516656 517745 525679 530026 530761 531862 533272 533707 536470 540868 541757 541760 543652 564563 569922 599833 599864 599961 599966 604061 604226 604387 605725 605742 613860 619802 624845 628363 632708 634157 643027 647895 647905 647936 648220 648235 666880 666902 666904 695882 703930 714028 725626 728465 738503 743706 756491 757393 760507 777046 782041 784848 787919 791363 795395 797178 800884 806022 806943 810299 811221 812495 815847 823368 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal sex squirt"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал секс сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.80%) |
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.