Query Metrics
7
Database Queries
7
Different statements
150.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.88 ms (84.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 7169 73246 130289 191048 233353 381435 382637 385582 387485 388187 390871 391537 391756 397853 397923 397937 403965 404731 404762 406899 407910 408383 409929 411368 411808 414125 416121 416166 417384 419130 419503 419617 420276 422673 423500 424001 424430 425353 428231 428407 442626 443326 446534 446872 449953 451960 452579 453131 455945 456809 460811 461366 463764 463840 463841 465949 466213 466432 468443 469508 472232 472750 472895 473194 473740 473908 474289 474702 478036 478510 480760 490849 495660 513220 520176 521166 522140 523841 532560 534553 535005 536380 541336 549036 555100 561068 569003 569147 589573 600276 609229 618856 637746 644323 646292 660147 663346 681031 681134 706658 707309 708438 716765 719025 748945 756462 758152 761073 764144 775976 786523 797949 801949 807635 807958 810827 814049 814429 818274 822278 ] |
||||||||||||||||||||||||||||||
|
13.94 ms (9.23%) |
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 490849 549036 388187 719025 756462 474702 385582 130289 390871 406899 442626 417384 419617 451960 480760 478510 532560 478036 555100 716765 569147 600276 609229 786523 419130 397853 404762 424001 473194 473740 443326 460811 416121 465949 707309 818274 758152 73246 681134 446534 407910 449953 495660 541336 472750 416166 463764 382637 428407 446872 520176 535005 797949 801949 425353 424430 414125 422673 391756 468443 764144 708438 387485 397937 822278 646292 7169 706658 474289 403965 404731 233353 814429 455945 472895 569003 589573 397923 466213 419503 521166 523841 618856 644323 191048 381435 411808 423500 814049 472232 522140 534553 513220 660147 681031 663346 637746 748945 807635 810827 761073 775976 807958 453131 461366 411368 391537 473908 420276 408383 409929 428231 456809 463840 466432 469508 463841 452579 536380 561068 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.66%) |
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 7169 73246 130289 191048 233353 381435 382637 385582 387485 388187 390871 391537 391756 397853 397923 397937 403965 404731 404762 406899 407910 408383 409929 411368 411808 414125 416121 416166 417384 419130 419503 419617 420276 422673 423500 424001 424430 425353 428231 428407 442626 443326 446534 446872 449953 451960 452579 453131 455945 456809 460811 461366 463764 463840 463841 465949 466213 466432 468443 469508 472232 472750 472895 473194 473740 473908 474289 474702 478036 478510 480760 490849 495660 513220 520176 521166 522140 523841 532560 534553 535005 536380 541336 549036 555100 561068 569003 569147 589573 600276 609229 618856 637746 644323 646292 660147 663346 681031 681134 706658 707309 708438 716765 719025 748945 756462 758152 761073 764144 775976 786523 797949 801949 807635 807958 810827 814049 814429 818274 822278 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf anal blonde"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf анал беловолосая"
]
|
||||||||||||||||||||||||||||||
|
1.21 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf анал беловолосая"
]
|
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.