Query Metrics
7
Database Queries
7
Different statements
177.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.75 ms (82.77%) |
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 29295 32549 46656 65989 75626 145706 154451 191509 203017 266061 366027 369221 383315 383354 384836 385059 385569 387953 391026 391250 391289 391985 395373 398928 403869 414268 420064 421967 422324 423539 423844 426724 427018 432496 432509 432878 433402 433761 435355 439600 441331 441806 444168 457091 464546 468534 475374 475956 483434 483554 489322 498996 507323 521692 523746 524124 524160 528228 533715 534974 537147 540622 541749 544865 554492 554747 555137 555640 557563 563330 567915 570412 585550 588334 590148 592994 600750 601295 603310 603359 605694 606286 613304 613558 614467 617258 619151 619894 635615 657788 664594 672792 672821 680819 687806 696774 696914 698882 707472 710337 725786 734322 741343 745806 749497 755322 756522 759923 764051 765411 776535 776807 777709 781053 781857 787646 799033 799731 803479 824138 ] |
||||||||||||||||||||||||||||||
|
19.94 ms (11.25%) |
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 475956 391250 803479 799731 590148 534974 29295 533715 672821 698882 696914 588334 710337 601295 613304 603359 489322 383315 563330 426724 756522 65989 203017 441331 433761 432496 696774 745806 781857 441806 483434 475374 385059 672792 777709 781053 749497 755322 391985 528228 524160 557563 554492 765411 191509 613558 635615 664594 617258 776807 734322 420064 498996 507323 266061 387953 432509 544865 523746 555137 423539 398928 799033 619894 614467 457091 435355 366027 46656 427018 540622 570412 145706 687806 600750 764051 759923 421967 483554 384836 554747 403869 555640 741343 725786 369221 423844 385569 537147 391026 521692 524124 787646 603310 619151 605694 414268 432878 154451 707472 824138 383354 32549 422324 433402 439600 444168 468534 567915 585550 592994 75626 391289 657788 606286 776535 541749 680819 395373 464546 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.45%) |
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 29295 32549 46656 65989 75626 145706 154451 191509 203017 266061 366027 369221 383315 383354 384836 385059 385569 387953 391026 391250 391289 391985 395373 398928 403869 414268 420064 421967 422324 423539 423844 426724 427018 432496 432509 432878 433402 433761 435355 439600 441331 441806 444168 457091 464546 468534 475374 475956 483434 483554 489322 498996 507323 521692 523746 524124 524160 528228 533715 534974 537147 540622 541749 544865 554492 554747 555137 555640 557563 563330 567915 570412 585550 588334 590148 592994 600750 601295 603310 603359 605694 606286 613304 613558 614467 617258 619151 619894 635615 657788 664594 672792 672821 680819 687806 696774 696914 698882 707472 710337 725786 734322 741343 745806 749497 755322 756522 759923 764051 765411 776535 776807 777709 781053 781857 787646 799033 799731 803479 824138 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"чулки пися"
]
|
||||||||||||||||||||||||||||||
|
2.20 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чулк нижн бел вагин"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.