Query Metrics
7
Database Queries
7
Different statements
460.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
226.24 ms (49.10%) |
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 67464 382426 382948 384038 384215 396527 397843 400946 406334 418133 419152 419571 421346 421484 422500 422604 422625 422656 422881 423039 423178 428241 433640 434338 439191 467073 468605 470956 491188 491364 492109 495670 498656 500974 502843 505634 507561 515604 515862 518837 520488 522225 522646 525555 528906 529182 540912 543711 544805 551957 551977 552482 553951 554105 554107 557498 558209 559548 560327 564001 581362 582393 584455 586761 590695 591172 591219 591380 593966 594469 594590 595767 599044 600005 605366 607381 610693 613484 626212 629926 630234 640494 643673 663444 674216 703263 712214 731994 734073 740109 742082 748947 752184 756480 765208 770951 778232 778360 780483 780624 781051 790361 791350 792017 795709 802319 809365 810467 811096 816777 818304 819592 821994 822979 823046 826139 826147 826251 828520 828850 ] |
||||||||||||||||||||||||||||||
|
206.37 ms (44.78%) |
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 67464 382426 382948 384038 384215 396527 397843 400946 406334 418133 419152 419571 421346 421484 422500 422604 422625 422656 422881 423039 423178 428241 433640 434338 439191 467073 468605 470956 491188 491364 492109 495670 498656 500974 502843 505634 507561 515604 515862 518837 520488 522225 522646 525555 528906 529182 540912 543711 544805 551957 551977 552482 553951 554105 554107 557498 558209 559548 560327 564001 581362 582393 584455 586761 590695 591172 591219 591380 593966 594469 594590 595767 599044 600005 605366 607381 610693 613484 626212 629926 630234 640494 643673 663444 674216 703263 712214 731994 734073 740109 742082 748947 752184 756480 765208 770951 778232 778360 780483 780624 781051 790361 791350 792017 795709 802319 809365 810467 811096 816777 818304 819592 821994 822979 823046 826139 826147 826251 828520 828850 ] |
||||||||||||||||||||||||||||||
|
20.94 ms (4.55%) |
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 742082 552482 828520 792017 810467 422500 396527 406334 551957 551977 770951 421484 765208 560327 610693 594469 600005 826147 826251 828850 629926 780624 790361 384038 423039 422625 428241 419571 491188 500974 522225 582393 554105 558209 663444 591380 591172 591219 586761 590695 470956 418133 422604 468605 434338 505634 515862 518837 491364 502843 495670 507561 599044 439191 826139 816777 818304 822979 581362 778232 734073 740109 712214 780483 382948 433640 643673 802319 781051 594590 67464 421346 595767 795709 756480 397843 467073 522646 630234 703263 674216 626212 605366 731994 400946 419152 422656 529182 554107 559548 564001 553951 584455 593966 423178 422881 528906 498656 492109 515604 520488 525555 540912 821994 823046 819592 543711 544805 557498 607381 613484 811096 748947 752184 640494 778360 791350 809365 382426 384215 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small tights"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.39%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая колготк"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.35%) |
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.