Query Metrics
7
Database Queries
7
Different statements
168.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.50 ms (85.85%) |
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 152479 152883 385254 389696 389978 392915 395504 398812 403268 404608 416299 457397 469640 481587 485029 489102 507158 509163 509500 517280 517479 540668 541035 541134 547101 553188 553831 557069 557794 568188 570746 581484 587978 588483 591883 592962 595142 597164 605226 609732 614183 617534 634473 636351 649276 655485 669277 671839 672213 676346 680542 684503 689477 690633 693230 693234 695415 705211 707155 708280 708621 710479 712485 714845 718456 719889 722678 724501 726467 726634 728351 730364 735463 737286 741468 746878 750140 757773 757982 767137 768269 768822 776737 777228 779804 781805 784081 784581 785679 787070 787400 787881 789860 792191 793113 794256 795492 796103 796968 797682 799387 801537 801540 801717 805056 807290 809242 809529 810948 813643 817912 817921 818000 818211 818833 819543 819913 820549 823406 823612 ] |
||||||||||||||||||||||||||||||
|
14.72 ms (8.74%) |
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 823612 689477 690633 655485 587978 781805 810948 777228 784581 793113 726467 741468 737286 768269 819543 557069 152883 568188 649276 634473 724501 819913 719889 597164 809529 787881 404608 517479 557794 693230 570746 614183 767137 416299 813643 541134 553831 695415 705211 592962 609732 787400 735463 787070 801717 389696 152479 392915 818000 818833 457397 517280 541035 669277 671839 672213 553188 581484 779804 801540 796968 784081 789860 750140 768822 707155 796103 799387 809242 398812 389978 818211 823406 817921 485029 489102 509163 676346 722678 680542 684503 714845 547101 591883 605226 588483 595142 792191 795492 801537 807290 794256 797682 757982 728351 730364 726634 710479 385254 509500 403268 817912 820549 507158 617534 757773 805056 693234 636351 785679 776737 746878 718456 395504 469640 481587 540668 708621 708280 712485 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.57%) |
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 152479 152883 385254 389696 389978 392915 395504 398812 403268 404608 416299 457397 469640 481587 485029 489102 507158 509163 509500 517280 517479 540668 541035 541134 547101 553188 553831 557069 557794 568188 570746 581484 587978 588483 591883 592962 595142 597164 605226 609732 614183 617534 634473 636351 649276 655485 669277 671839 672213 676346 680542 684503 689477 690633 693230 693234 695415 705211 707155 708280 708621 710479 712485 714845 718456 719889 722678 724501 726467 726634 728351 730364 735463 737286 741468 746878 750140 757773 757982 767137 768269 768822 776737 777228 779804 781805 784081 784581 785679 787070 787400 787881 789860 792191 793113 794256 795492 796103 796968 797682 799387 801537 801540 801717 805056 807290 809242 809529 810948 813643 817912 817921 818000 818211 818833 819543 819913 820549 823406 823612 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hotel fuck"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hotel секс"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hotel секс"
]
|
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.