Query Metrics
7
Database Queries
7
Different statements
197.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.93 ms (85.53%) |
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 25080 282430 388469 395819 403353 411169 411684 417716 419432 428112 429379 429939 441280 442987 445292 446533 446908 447551 450122 450187 450286 451624 452769 452805 453794 454756 459484 459489 459499 459541 460318 460403 464250 465837 465923 467951 470118 477032 478310 480260 480302 480724 484224 486293 489316 489488 492523 496831 522970 525376 528057 532932 541760 552209 558736 565847 565957 566878 568471 574465 586965 598836 605129 605339 614328 620645 633813 636956 641938 644330 645669 651851 652099 660067 661912 662033 665051 666868 676531 677346 677352 677363 707609 712558 712720 721984 724509 727668 727754 727789 732262 736099 736822 738912 742886 747518 756230 758114 759950 761466 762913 766646 772039 777580 779119 784621 787297 788852 791406 796939 799270 802024 805355 810214 816423 817608 818426 818591 818824 826048 ] |
||||||||||||||||||||||||||||||
|
16.68 ms (8.45%) |
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 417716 541760 605339 459489 464250 459484 442987 441280 460403 467951 788852 452769 447551 459541 489488 486293 660067 477032 480302 566878 645669 665051 676531 586965 620645 636956 727668 761466 738912 727789 736099 747518 758114 766646 644330 707609 796939 525376 465923 558736 651851 756230 429939 489316 661912 677363 565957 810214 759950 450122 388469 818824 762913 772039 779119 784621 816423 818591 532932 419432 411169 712720 652099 662033 641938 802024 727754 736822 742886 25080 818426 452805 395819 451624 565847 450286 492523 568471 787297 429379 411684 445292 450187 453794 470118 484224 614328 799270 791406 465837 282430 403353 459499 522970 528057 428112 598836 454756 826048 721984 805355 666868 478310 480724 633813 446908 574465 817608 460318 552209 712558 677346 677352 605129 777580 732262 724509 480260 496831 446533 ] |
||||||||||||||||||||||||||||||
|
4.18 ms (2.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 25080 282430 388469 395819 403353 411169 411684 417716 419432 428112 429379 429939 441280 442987 445292 446533 446908 447551 450122 450187 450286 451624 452769 452805 453794 454756 459484 459489 459499 459541 460318 460403 464250 465837 465923 467951 470118 477032 478310 480260 480302 480724 484224 486293 489316 489488 492523 496831 522970 525376 528057 532932 541760 552209 558736 565847 565957 566878 568471 574465 586965 598836 605129 605339 614328 620645 633813 636956 641938 644330 645669 651851 652099 660067 661912 662033 665051 666868 676531 677346 677352 677363 707609 712558 712720 721984 724509 727668 727754 727789 732262 736099 736822 738912 742886 747518 756230 758114 759950 761466 762913 766646 772039 777580 779119 784621 787297 788852 791406 796939 799270 802024 805355 810214 816423 817608 818426 818591 818824 826048 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал большие sexy"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал большие sexy"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal big sexy"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.91%) |
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.