Query Metrics
7
Database Queries
7
Different statements
195.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.44 ms (85.32%) |
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 391582 397927 397997 400990 409709 418099 419612 428281 431503 438589 442447 443321 450338 451518 456550 461621 464046 470598 470708 471674 475201 475350 475934 477154 479167 479485 479723 484755 485295 486227 486736 489106 490768 490978 493875 496059 496295 500327 500984 503071 504145 504599 507332 509408 510139 512714 513457 513588 516552 516827 517519 518320 518539 520075 520936 521496 523275 523707 523953 524741 524981 525552 526298 527887 529008 529295 530187 530259 530548 533969 535222 535332 542728 542955 544153 546634 546876 547028 549023 550506 552605 553591 554704 555253 556072 556090 556976 557306 557883 561030 561600 563765 564559 573169 573217 574300 575342 575707 581336 583612 584707 584903 585842 586700 588347 595637 597214 599797 602351 605085 605257 612092 613676 615616 617395 618101 622840 639241 652010 804883 ] |
||||||||||||||||||||||||||||||
|
18.08 ms (9.27%) |
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 500984 523275 496059 475201 512714 586700 461621 605085 503071 530187 510139 523953 490768 496295 518539 556072 561600 574300 595637 605257 475350 525552 504599 516827 520936 524741 535332 544153 563765 585842 612092 581336 529008 490978 552605 530548 533969 516552 523707 486227 542728 652010 553591 556976 597214 618101 613676 639241 489106 418099 419612 443321 409709 431503 442447 470598 479723 479167 485295 500327 520075 521496 509408 518320 471674 477154 547028 556090 573217 546634 549023 575707 557883 554704 584707 588347 400990 391582 428281 438589 470708 479485 450338 475934 526298 484755 524981 504145 397927 397997 464046 486736 513457 529295 535222 507332 527887 530259 550506 546876 555253 564559 575342 583612 557306 573169 615616 599797 804883 602351 451518 517519 561030 513588 617395 542955 622840 493875 584903 456550 ] |
||||||||||||||||||||||||||||||
|
3.79 ms (1.94%) |
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 391582 397927 397997 400990 409709 418099 419612 428281 431503 438589 442447 443321 450338 451518 456550 461621 464046 470598 470708 471674 475201 475350 475934 477154 479167 479485 479723 484755 485295 486227 486736 489106 490768 490978 493875 496059 496295 500327 500984 503071 504145 504599 507332 509408 510139 512714 513457 513588 516552 516827 517519 518320 518539 520075 520936 521496 523275 523707 523953 524741 524981 525552 526298 527887 529008 529295 530187 530259 530548 533969 535222 535332 542728 542955 544153 546634 546876 547028 549023 550506 552605 553591 554704 555253 556072 556090 556976 557306 557883 561030 561600 563765 564559 573169 573217 574300 575342 575707 581336 583612 584707 584903 585842 586700 588347 595637 597214 599797 602351 605085 605257 612092 613676 615616 617395 618101 622840 639241 652010 804883 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"реальное в одежде"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск в одежд"
]
|
||||||||||||||||||||||||||||||
|
1.22 ms (0.63%) |
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.