Query Metrics
7
Database Queries
7
Different statements
184.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.86 ms (84.88%) |
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 13118 41776 90485 150798 187289 373746 384139 387235 387720 388421 388424 388628 389144 391744 396699 397316 399516 401361 402833 403373 403434 405913 406469 408509 410577 415292 417395 420200 422074 422623 425370 425946 425958 426431 427000 428250 432663 435726 442157 444776 445470 452892 454882 455598 459880 460293 465843 469060 469101 470863 472023 479727 484155 485338 485801 491101 493083 497130 499269 507370 509195 510585 515459 519249 520917 522730 523726 526021 526941 545698 582179 585020 591455 593292 612799 623413 702320 720701 721006 725382 731801 734824 734825 734850 740489 740505 744627 746997 747690 748982 750410 752132 752538 756241 758199 760381 760392 760567 760615 765907 776022 776138 778364 784874 787950 788443 788805 789892 790101 790249 792789 803183 804995 805257 809429 810939 812025 812105 816541 827120 ] |
||||||||||||||||||||||||||||||
|
17.59 ms (9.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 591455 776138 778364 788443 790249 804995 809429 788805 789892 790101 734824 744627 748982 750410 752132 760381 787950 792789 810939 812105 731801 740489 756241 760392 734825 734850 740505 747690 752538 725382 746997 758199 760567 760615 765907 702320 720701 721006 776022 784874 803183 805257 812025 150798 401361 410577 425958 445470 469101 426431 455598 465843 469060 479727 406469 415292 417395 427000 452892 454882 459880 13118 41776 90485 388424 470863 460293 472023 509195 523726 526021 526941 499269 484155 491101 493083 497130 520917 485338 485801 507370 510585 522730 582179 623413 515459 519249 545698 593292 612799 384139 187289 391744 373746 388421 388628 389144 387235 387720 396699 397316 399516 402833 403373 403434 405913 422623 425370 442157 408509 422074 420200 428250 432663 435726 425946 444776 585020 827120 816541 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (1.71%) |
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 13118 41776 90485 150798 187289 373746 384139 387235 387720 388421 388424 388628 389144 391744 396699 397316 399516 401361 402833 403373 403434 405913 406469 408509 410577 415292 417395 420200 422074 422623 425370 425946 425958 426431 427000 428250 432663 435726 442157 444776 445470 452892 454882 455598 459880 460293 465843 469060 469101 470863 472023 479727 484155 485338 485801 491101 493083 497130 499269 507370 509195 510585 515459 519249 520917 522730 523726 526021 526941 545698 582179 585020 591455 593292 612799 623413 702320 720701 721006 725382 731801 734824 734825 734850 740489 740505 744627 746997 747690 748982 750410 752132 752538 756241 758199 760381 760392 760567 760615 765907 776022 776138 778364 784874 787950 788443 788805 789892 790101 790249 792789 803183 804995 805257 809429 810939 812025 812105 816541 827120 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"man toys"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мужчин toys"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мужчин toys"
]
|
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.