Query Metrics
7
Database Queries
7
Different statements
194.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.77 ms (87.42%) |
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 91829 212012 240689 328286 383448 387446 387744 388707 397760 409692 423539 425502 426465 428098 431585 432544 432559 432706 433740 435355 437146 442463 445841 447820 449719 450842 455553 456115 456667 462226 462981 463446 466759 472624 478561 479752 481442 484296 484503 485251 492057 495088 499549 500067 503486 505975 508222 508228 509673 510929 516277 516486 521174 521853 523327 523746 524176 526631 528203 532488 533298 539438 539648 546593 554998 555137 555227 555784 560305 563744 565008 566399 567615 568181 571940 588881 589081 589308 592785 592938 592994 593100 600438 605074 605902 613513 620432 631569 635689 637172 647399 660581 671219 674549 689147 720319 725454 726317 738331 758357 758367 760988 764653 776215 780315 784121 786405 787173 790271 790490 801125 801326 812029 814476 816655 823965 824270 827546 827735 ] |
||||||||||||||||||||||||||||||
|
14.61 ms (7.52%) |
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 784121 801326 812029 383448 432544 450842 447820 449719 660581 516486 432706 456115 526631 563744 593100 635689 484503 786405 725454 790271 212012 801125 764653 780315 790490 426465 481442 484296 539648 510929 546593 555784 671219 554998 600438 631569 588881 605074 605902 637172 432559 500067 566399 91829 387744 387446 397760 816655 827546 823965 828024 827735 533298 567615 555227 720319 758357 758367 388707 528203 814476 760988 738331 568181 442463 589081 592994 726317 776215 431585 509673 589308 240689 328286 409692 428098 433740 462226 478561 479752 492057 674549 499549 521174 503486 516277 532488 508228 647399 689147 613513 524176 495088 456667 445841 505975 592938 592785 437146 462981 425502 463446 508222 523327 485251 565008 560305 620432 472624 824270 787173 466759 539438 523746 521853 571940 555137 455553 423539 435355 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.39%) |
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 91829 212012 240689 328286 383448 387446 387744 388707 397760 409692 423539 425502 426465 428098 431585 432544 432559 432706 433740 435355 437146 442463 445841 447820 449719 450842 455553 456115 456667 462226 462981 463446 466759 472624 478561 479752 481442 484296 484503 485251 492057 495088 499549 500067 503486 505975 508222 508228 509673 510929 516277 516486 521174 521853 523327 523746 524176 526631 528203 532488 533298 539438 539648 546593 554998 555137 555227 555784 560305 563744 565008 566399 567615 568181 571940 588881 589081 589308 592785 592938 592994 593100 600438 605074 605902 613513 620432 631569 635689 637172 647399 660581 671219 674549 689147 720319 725454 726317 738331 758357 758367 760988 764653 776215 780315 784121 786405 787173 790271 790490 801125 801326 812029 814476 816655 823965 824270 827546 827735 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"panties wife"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"трусик нижн бел жен"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"трусик нижн бел жен"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.85%) |
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.