Query Metrics
7
Database Queries
7
Different statements
224.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
195.08 ms (86.82%) |
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 13646 53386 68560 76836 96445 96623 118900 182749 187098 233025 295700 297519 382121 383517 384208 388648 390258 399591 404116 405995 408163 409357 415249 415313 415978 419075 420267 420835 422513 423460 424562 424593 427045 427209 427878 429786 429898 435233 435576 436257 436977 437360 441866 446860 447028 448969 449290 450584 452425 453152 453529 454840 454855 457625 460280 467077 467982 468616 469955 472108 474823 477491 482211 485809 487283 489448 495077 498993 504639 508423 509195 512439 513576 513667 519542 526021 529033 553286 558115 561061 561287 568202 581638 581661 583091 593125 598806 599402 606275 617183 619555 620576 624851 640055 686064 712162 712831 714126 731174 737382 748874 751656 755966 760381 760392 766043 776523 784047 789223 795530 806995 812299 812511 814299 816591 820699 824355 824999 827465 827737 ] |
||||||||||||||||||||||||||||||
|
19.52 ms (8.69%) |
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 606275 640055 429898 415249 427209 529033 118900 297519 53386 96445 182749 429786 420835 441866 814299 824355 827737 827465 448969 472108 477491 446860 447028 467077 553286 712831 714126 686064 581661 599402 624851 617183 620576 795530 737382 751656 755966 766043 731174 712162 776523 784047 812511 233025 96623 295700 460280 485809 512439 487283 504639 390258 424593 453152 513667 581638 812299 748874 454855 13646 469955 435576 452425 405995 498993 561287 583091 619555 187098 399591 420267 415978 482211 561061 427878 454840 422513 453529 519542 513576 598806 593125 404116 408163 457625 467982 468616 508423 558115 568202 806995 760381 789223 760392 424562 68560 449290 509195 526021 495077 76836 383517 384208 382121 388648 415313 419075 423460 436257 436977 427045 437360 435233 409357 816591 820699 824999 474823 489448 450584 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.12%) |
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 13646 53386 68560 76836 96445 96623 118900 182749 187098 233025 295700 297519 382121 383517 384208 388648 390258 399591 404116 405995 408163 409357 415249 415313 415978 419075 420267 420835 422513 423460 424562 424593 427045 427209 427878 429786 429898 435233 435576 436257 436977 437360 441866 446860 447028 448969 449290 450584 452425 453152 453529 454840 454855 457625 460280 467077 467982 468616 469955 472108 474823 477491 482211 485809 487283 489448 495077 498993 504639 508423 509195 512439 513576 513667 519542 526021 529033 553286 558115 561061 561287 568202 581638 581661 583091 593125 598806 599402 606275 617183 619555 620576 624851 640055 686064 712162 712831 714126 731174 737382 748874 751656 755966 760381 760392 766043 776523 784047 789223 795530 806995 812299 812511 814299 816591 820699 824355 824999 827465 827737 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мужчин мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"man masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.81%) |
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.