Query Metrics
7
Database Queries
7
Different statements
195.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.17 ms (88.15%) |
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 96443 130022 209373 388648 396069 398204 400459 400537 400810 408508 413099 419623 428940 431673 446331 447314 452018 456660 469675 474027 478545 488732 494408 512034 512182 515895 516844 521877 523398 528808 528809 533065 536399 537199 540339 542953 548265 548893 552000 552022 556362 556408 556453 557162 558619 560432 571674 575217 575695 575803 576062 583967 589134 595767 595777 595825 597231 597235 597271 597559 603207 603232 604474 605332 606554 606570 607354 613856 620785 622191 622225 622236 634462 644274 645944 651151 651620 653139 653154 655088 659284 659311 659329 661251 670958 672355 674119 676345 679099 680151 680159 680182 680188 680493 683272 683802 684088 694117 694607 698140 715798 718955 719640 721600 731816 731950 731994 731999 732954 749918 780530 788182 800019 806422 807148 807196 807200 819193 828157 ] |
||||||||||||||||||||||||||||||
|
12.46 ms (6.38%) |
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 452018 540339 537199 571674 680182 680159 597231 597235 597559 523398 533065 560432 575803 680151 684088 651620 680188 548265 575217 576062 597271 589134 780530 446331 456660 469675 209373 400459 431673 447314 528809 488732 521877 528808 130022 388648 828157 494408 515895 512182 516844 575695 552000 556408 548893 683802 718955 645944 653154 670958 715798 721600 651151 659329 674119 556453 606570 607354 622191 595825 603207 788182 732954 807148 807200 749918 731950 604474 622236 396069 398204 408508 428940 819193 478545 536399 512034 558619 542953 552022 557162 659284 676345 679099 694117 694607 698140 655088 661251 680493 683272 653139 659311 672355 556362 583967 595767 629530 605332 606554 613856 622225 634462 595777 603232 806422 807196 731999 731816 731994 620785 644274 719640 800019 419623 474027 413099 96443 400537 400810 ] |
||||||||||||||||||||||||||||||
|
4.31 ms (2.20%) |
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 96443 130022 209373 388648 396069 398204 400459 400537 400810 408508 413099 419623 428940 431673 446331 447314 452018 456660 469675 474027 478545 488732 494408 512034 512182 515895 516844 521877 523398 528808 528809 533065 536399 537199 540339 542953 548265 548893 552000 552022 556362 556408 556453 557162 558619 560432 571674 575217 575695 575803 576062 583967 589134 595767 595777 595825 597231 597235 597271 597559 603207 603232 604474 605332 606554 606570 607354 613856 620785 622191 622225 622236 634462 644274 645944 651151 651620 653139 653154 655088 659284 659311 659329 661251 670958 672355 674119 676345 679099 680151 680159 680182 680188 680493 683272 683802 684088 694117 694607 698140 715798 718955 719640 721600 731816 731950 731994 731999 732954 749918 780530 788182 800019 806422 807148 807196 807200 819193 828157 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые group"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny group"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые group"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.69%) |
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.