Query Metrics
7
Database Queries
7
Different statements
190.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.21 ms (85.00%) |
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 7206 7295 7373 13428 13775 89135 181308 291356 382172 382316 382885 384144 388169 391624 395373 397431 397498 397953 398508 398577 398745 400004 400032 400540 402007 402232 404390 405906 407045 409805 411436 418013 424125 428603 433920 435117 436844 439138 439350 439504 441131 441415 444052 445642 448001 449678 454536 456115 462985 464451 464895 465878 467113 468339 473193 475956 478095 478702 488023 506518 526608 529912 530448 533986 536406 536887 541859 544445 549165 559068 565838 571086 580425 583581 588461 591341 593004 599081 602102 602482 609999 610466 626247 626569 639208 639755 646211 673670 685378 702632 712939 718054 719929 726194 726317 727761 735696 740826 743076 745716 760988 765238 768751 769071 775234 782071 782556 783081 787959 791518 798740 800329 800429 801688 802151 809356 813181 816112 823965 ] |
||||||||||||||||||||||||||||||
|
18.17 ms (9.52%) |
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 411436 391624 382172 802151 405906 712939 768751 397431 526608 424125 13775 787959 800429 89135 726317 610466 783081 544445 467113 536887 400032 799895 743076 745716 769071 719929 798740 445642 549165 397498 782071 801688 541859 473193 402232 400540 488023 456115 593004 397953 673670 646211 439350 727761 565838 404390 464451 536406 454536 775234 765238 740826 407045 439138 602482 782556 583581 444052 726194 435117 478095 530448 580425 588461 448001 436844 823965 702632 559068 791518 760988 395373 382316 13428 384144 398508 418013 685378 400004 388169 462985 533986 813181 529912 599081 602102 639208 428603 449678 398577 816112 291356 478702 181308 7373 626247 591341 439504 464895 718054 398745 441415 441131 626569 639755 809356 800329 409805 465878 475956 7206 468339 571086 735696 506518 609999 433920 7295 382885 402007 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.46%) |
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 7206 7295 7373 13428 13775 89135 181308 291356 382172 382316 382885 384144 388169 391624 395373 397431 397498 397953 398508 398577 398745 400004 400032 400540 402007 402232 404390 405906 407045 409805 411436 418013 424125 428603 433920 435117 436844 439138 439350 439504 441131 441415 444052 445642 448001 449678 454536 456115 462985 464451 464895 465878 467113 468339 473193 475956 478095 478702 488023 506518 526608 529912 530448 533986 536406 536887 541859 544445 549165 559068 565838 571086 580425 583581 588461 591341 593004 599081 602102 602482 609999 610466 626247 626569 639208 639755 646211 673670 685378 702632 712939 718054 719929 726194 726317 727761 735696 740826 743076 745716 760988 765238 768751 769071 775234 782071 782556 783081 787959 791518 798740 800329 800429 801688 802151 809356 813181 816112 823965 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"panties anal"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"трусик нижн бел анал"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"трусик нижн бел анал"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.93%) |
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.