Query Metrics
7
Database Queries
7
Different statements
369.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.12 ms (56.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde tights"
]
|
||||||||||||||||||||||||||||||
|
128.52 ms (34.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 45853 133695 161969 186592 212750 212982 213057 213330 213692 290232 318700 325648 329508 383440 384864 384878 385216 385992 386839 390734 394670 395633 400811 400847 402306 402530 409652 411373 411421 416675 417521 418724 423521 424502 428241 432297 444895 446086 446252 447694 448487 450748 452260 459614 464336 464502 466027 472898 478125 478131 480389 485437 491188 496781 502843 505333 505634 514443 516055 516778 521093 523168 529015 530007 531945 539208 542987 551269 554097 554524 555065 555567 564597 567860 569440 572954 576728 584793 590613 597051 597550 600384 603507 605864 618856 620228 620250 644707 669907 716621 717410 717610 725138 728167 728172 748690 752359 755355 755442 756409 757803 758417 769158 771867 772021 781189 786438 795149 795858 797262 798573 802460 807383 809328 811095 812697 814049 819009 823103 828633 ] |
||||||||||||||||||||||||||||||
|
22.97 ms (6.22%) |
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 496781 644707 620228 795858 809328 786438 755442 290232 485437 828633 386839 505333 539208 576728 597051 758417 769158 797262 728172 752359 771867 781189 798573 402530 213057 446252 480389 447694 466027 542987 569440 424502 444895 448487 478125 478131 516778 521093 531945 755355 161969 384864 133695 464502 554524 717610 600384 802460 811095 748690 812697 756409 728167 725138 395633 472898 384878 450748 605864 417521 325648 411373 823103 385216 329508 400847 409652 428241 491188 584793 554097 564597 567860 590613 807383 416675 452260 411421 385992 459614 505634 502843 523168 530007 618856 620250 446086 669907 717410 551269 555065 603507 772021 795149 516055 212750 186592 716621 212982 402306 383440 318700 418724 464336 572954 514443 597550 213692 45853 819009 529015 757803 394670 213330 400811 814049 390734 423521 432297 555567 ] |
||||||||||||||||||||||||||||||
|
3.70 ms (1.00%) |
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 45853 133695 161969 186592 212750 212982 213057 213330 213692 290232 318700 325648 329508 383440 384864 384878 385216 385992 386839 390734 394670 395633 400811 400847 402306 402530 409652 411373 411421 416675 417521 418724 423521 424502 428241 432297 444895 446086 446252 447694 448487 450748 452260 459614 464336 464502 466027 472898 478125 478131 480389 485437 491188 496781 502843 505333 505634 514443 516055 516778 521093 523168 529015 530007 531945 539208 542987 551269 554097 554524 555065 555567 564597 567860 569440 572954 576728 584793 590613 597051 597550 600384 603507 605864 618856 620228 620250 644707 669907 716621 717410 717610 725138 728167 728172 748690 752359 755355 755442 756409 757803 758417 769158 771867 772021 781189 786438 795149 795858 797262 798573 802460 807383 809328 811095 812697 814049 819009 823103 828633 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.58%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая колготк"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (0.56%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.42%) |
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.