Query Metrics
7
Database Queries
7
Different statements
192.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.35 ms (87.16%) |
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 382633 390650 397478 404119 415977 429020 438339 438518 438655 439146 441222 442645 442705 442983 445419 446561 449963 450277 452850 452873 455640 457379 459182 460167 467560 471082 476475 478991 491881 509113 517540 524864 527122 528320 528530 529230 534858 536377 538703 541328 541541 541971 542764 544001 545905 546972 546981 547945 554372 555131 559427 561971 568134 568864 570940 571708 577695 577719 587283 588467 589408 590788 592482 597763 598049 601412 605184 614702 619791 620633 627311 636638 640143 644510 649306 650915 652974 669668 686331 706446 710771 737140 738564 742092 744022 744047 745915 749237 754209 754480 759130 783939 786878 789786 791132 794243 796695 797180 801016 801394 801825 803619 804422 804441 804458 806321 806930 806937 807067 808585 808623 810099 810798 812273 812279 814459 814467 814477 823790 824870 ] |
||||||||||||||||||||||||||||||
|
15.34 ms (7.99%) |
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 598049 614702 636638 640143 587283 589408 592482 597763 601412 619791 588467 605184 620633 789786 794243 797180 801394 803619 807067 808623 810798 812279 796695 801016 801825 804441 806930 808585 812273 744047 783939 786878 806937 744022 738564 759130 737140 742092 745915 749237 754209 754480 627311 644510 791132 804422 804458 806321 810099 397478 404119 476475 509113 517540 478991 538703 590788 467560 382633 390650 429020 438518 442645 438655 438339 439146 441222 442983 415977 442705 445419 814477 824870 814467 814459 823790 446561 449963 455640 457379 491881 452873 459182 471082 450277 452850 528530 534858 524864 527122 528320 536377 529230 460167 542764 561971 570940 571708 577695 541328 541971 545905 546972 547945 568134 577719 541541 544001 546981 554372 555131 559427 568864 669668 686331 649306 650915 652974 706446 710771 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam shower solo"
]
|
||||||||||||||||||||||||||||||
|
2.26 ms (1.18%) |
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 382633 390650 397478 404119 415977 429020 438339 438518 438655 439146 441222 442645 442705 442983 445419 446561 449963 450277 452850 452873 455640 457379 459182 460167 467560 471082 476475 478991 491881 509113 517540 524864 527122 528320 528530 529230 534858 536377 538703 541328 541541 541971 542764 544001 545905 546972 546981 547945 554372 555131 559427 561971 568134 568864 570940 571708 577695 577719 587283 588467 589408 590788 592482 597763 598049 601412 605184 614702 619791 620633 627311 636638 640143 644510 649306 650915 652974 669668 686331 706446 710771 737140 738564 742092 744022 744047 745915 749237 754209 754480 759130 783939 786878 789786 791132 794243 796695 797180 801016 801394 801825 803619 804422 804441 804458 806321 806930 806937 807067 808585 808623 810099 810798 812273 812279 814459 814467 814477 823790 824870 ] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер shower соло"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер shower соло"
]
|
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.