Query Metrics
7
Database Queries
7
Different statements
150.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.82 ms (82.68%) |
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 6983 39478 79570 107362 150488 364620 382744 385340 385388 385475 386194 386346 386674 386743 388584 389226 390851 391897 392217 396172 397089 400598 401830 401900 402007 402450 406793 407438 417720 421445 426104 428852 429654 433636 439006 442016 445583 445704 447224 449279 451610 454014 455582 456187 457212 459012 459048 459444 460189 463394 466612 469364 469402 470973 472842 476407 478392 479362 479776 481218 485842 488574 489478 493021 493981 496423 498877 500778 503020 507128 511034 512757 513196 518340 521125 521533 524959 526839 528594 538782 547381 552161 557133 561006 561347 563241 563923 564778 565352 568551 568730 569511 570974 571003 571312 571620 572124 572396 573578 576333 580990 584843 586763 594878 596619 597194 603525 611044 612926 624541 630903 635752 640336 640684 659459 740985 742833 754230 756524 796553 ] |
||||||||||||||||||||||||||||||
|
15.31 ms (10.14%) |
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 612926 386194 479362 6983 389226 396172 459048 429654 479776 481218 526839 500778 489478 493021 397089 445704 521125 386346 428852 511034 640684 385475 79570 386743 385388 107362 391897 390851 401900 456187 459444 454014 503020 538782 498877 547381 561347 584843 563923 571003 571620 659459 597194 611044 640336 586763 630903 742833 756524 603525 796553 426104 39478 386674 447224 457212 521533 512757 388584 421445 442016 417720 485842 488574 576333 463394 364620 382744 401830 451610 466612 472842 449279 493981 564778 573578 552161 561006 570974 580990 565352 635752 754230 402007 445583 476407 433636 470973 385340 496423 596619 528594 150488 392217 400598 402450 407438 406793 439006 459012 469364 455582 460189 507128 513196 524959 518340 469402 568730 571312 572124 569511 557133 563241 568551 572396 594878 624541 740985 478392 ] |
||||||||||||||||||||||||||||||
|
3.49 ms (2.31%) |
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 6983 39478 79570 107362 150488 364620 382744 385340 385388 385475 386194 386346 386674 386743 388584 389226 390851 391897 392217 396172 397089 400598 401830 401900 402007 402450 406793 407438 417720 421445 426104 428852 429654 433636 439006 442016 445583 445704 447224 449279 451610 454014 455582 456187 457212 459012 459048 459444 460189 463394 466612 469364 469402 470973 472842 476407 478392 479362 479776 481218 485842 488574 489478 493021 493981 496423 498877 500778 503020 507128 511034 512757 513196 518340 521125 521533 524959 526839 528594 538782 547381 552161 557133 561006 561347 563241 563923 564778 565352 568551 568730 569511 570974 571003 571312 571620 572124 572396 573578 576333 580990 584843 586763 594878 596619 597194 603525 611044 612926 624541 630903 635752 640336 640684 659459 740985 742833 754230 756524 796553 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в розовых"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в розов"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.06%) |
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.