Query Metrics
7
Database Queries
7
Different statements
180.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.60 ms (85.29%) |
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 54149 168297 381859 392544 400102 431724 451631 453284 476652 490778 490787 491131 501333 506568 510354 513451 515315 523349 524847 529260 530170 534509 535189 538044 540357 541642 541780 541962 542331 547127 549420 549550 557009 559830 566299 566818 569365 569774 575408 577838 580115 580600 582518 584196 585357 585490 588217 598270 601421 602775 607802 607903 608085 608466 609895 615256 617994 622477 626571 627981 632496 642175 646111 647229 648736 654228 660970 662481 662803 675037 675630 681538 687126 687366 691614 692548 693267 700223 700268 700377 703019 706799 714209 714933 716126 717442 718284 720182 722296 724590 731123 731503 735064 740633 741273 742319 744102 746286 749786 753543 754276 754476 758589 759809 760922 761271 764087 765995 767003 771903 775652 778096 779027 779055 784416 787482 787816 794688 795443 805213 ] |
||||||||||||||||||||||||||||||
|
16.08 ms (8.93%) |
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 642175 588217 779055 744102 758589 761271 787482 754276 759809 541642 381859 490787 534509 523349 547127 575408 541962 582518 675630 714933 718284 654228 662803 681538 692548 675037 687366 700223 703019 549550 627981 608085 632496 805213 779027 731123 731503 765995 735064 741273 724590 760922 754476 749786 767003 771903 615256 431724 168297 510354 513451 662481 541780 54149 476652 453284 491131 524847 530170 540357 529260 501333 506568 538044 549420 557009 542331 566299 569774 577838 580115 580600 559830 569365 691614 693267 706799 647229 648736 660970 700268 720182 722296 646111 687126 714209 716126 566818 584196 607903 609895 622477 585357 585490 598270 601421 617994 607802 775652 787816 778096 742319 746286 784416 753543 764087 740633 602775 608466 700377 717442 795443 392544 626571 794688 400102 451631 490778 515315 535189 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.42%) |
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 54149 168297 381859 392544 400102 431724 451631 453284 476652 490778 490787 491131 501333 506568 510354 513451 515315 523349 524847 529260 530170 534509 535189 538044 540357 541642 541780 541962 542331 547127 549420 549550 557009 559830 566299 566818 569365 569774 575408 577838 580115 580600 582518 584196 585357 585490 588217 598270 601421 602775 607802 607903 608085 608466 609895 615256 617994 622477 626571 627981 632496 642175 646111 647229 648736 654228 660970 662481 662803 675037 675630 681538 687126 687366 691614 692548 693267 700223 700268 700377 703019 706799 714209 714933 716126 717442 718284 720182 722296 724590 731123 731503 735064 740633 741273 742319 744102 746286 749786 753543 754276 754476 758589 759809 760922 761271 764087 765995 767003 771903 775652 778096 779027 779055 784416 787482 787816 794688 795443 805213 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"стонет молодые"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"стонет молодые"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"стонет молодые"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.