Query Metrics
7
Database Queries
7
Different statements
176.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.87 ms (85.95%) |
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 108555 152479 152973 382801 388226 389696 389978 398128 398556 416299 427798 443950 469153 485029 489102 509163 511129 513935 515029 517280 517479 530095 534572 539654 547101 553188 553831 557069 557794 571831 579696 587025 587978 588483 595142 596905 596983 597164 602051 602137 605226 609732 617914 621727 623372 630016 630836 633030 633179 655485 660804 661647 668732 669277 672213 674280 680542 684886 690633 691148 692475 692752 695405 695415 695773 697221 701677 702300 705211 707217 707608 710489 711625 717456 718448 721605 723575 723807 728712 729316 730364 730473 730614 732984 732986 737286 739200 750140 750652 751508 753628 762499 765839 773267 777228 779804 784581 786477 787070 787845 789030 789070 790520 791753 792191 793113 794144 794256 795492 798762 800081 800596 801537 804177 807410 810948 813477 818833 819448 824488 ] |
||||||||||||||||||||||||||||||
|
14.08 ms (7.97%) |
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 152973 152479 547101 732984 108555 388226 416299 427798 723575 824488 819448 553831 691148 690633 695415 702300 655485 661647 684886 692752 705211 717456 721605 587978 617914 609732 602051 630016 623372 789030 791753 810948 777228 784581 793113 804177 730614 739200 762499 765839 730473 737286 728712 750652 751508 633030 710489 786477 787070 800596 389696 695773 389978 818833 605226 630836 794144 398556 511129 718448 773267 443950 398128 382801 485029 489102 469153 509163 517280 539654 513935 534572 515029 517479 530095 557794 571831 579696 660804 695405 711625 668732 669277 692475 697221 707217 707608 672213 674280 680542 701677 553188 557069 587025 633179 588483 602137 621727 595142 596905 596983 597164 779804 789070 792191 795492 798762 807410 787845 790520 800081 801537 723807 794256 813477 753628 729316 732986 750140 730364 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.70%) |
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 108555 152479 152973 382801 388226 389696 389978 398128 398556 416299 427798 443950 469153 485029 489102 509163 511129 513935 515029 517280 517479 530095 534572 539654 547101 553188 553831 557069 557794 571831 579696 587025 587978 588483 595142 596905 596983 597164 602051 602137 605226 609732 617914 621727 623372 630016 630836 633030 633179 655485 660804 661647 668732 669277 672213 674280 680542 684886 690633 691148 692475 692752 695405 695415 695773 697221 701677 702300 705211 707217 707608 710489 711625 717456 718448 721605 723575 723807 728712 729316 730364 730473 730614 732984 732986 737286 739200 750140 750652 751508 753628 762499 765839 773267 777228 779804 784581 786477 787070 787845 789030 789070 790520 791753 792191 793113 794144 794256 795492 798762 800081 800596 801537 804177 807410 810948 813477 818833 819448 824488 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hotel wife"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hotel жен"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.