Query Metrics
7
Database Queries
7
Different statements
175.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.96 ms (88.07%) |
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 391156 398539 400807 411948 446624 446629 447157 447163 453100 454225 454267 455436 455910 461016 463171 464960 466077 466982 466989 467035 467036 467043 474120 474400 474826 474874 480745 483355 483368 484643 487341 487938 489495 491790 498722 499112 502034 504823 510813 518848 522594 524887 525138 525492 526843 531321 531391 532125 533492 537942 539548 539605 545012 545895 546143 547048 549239 549245 549430 549880 557135 558286 574384 612273 637743 644684 653925 666766 674333 675544 678778 678790 678791 697707 707295 710453 714159 731812 732959 733506 734113 736000 738323 746739 748017 755499 760585 770154 771336 771342 771347 772875 774318 775972 780658 789250 789665 790881 792577 792598 795273 804274 810019 811083 812518 814125 817694 817803 818659 818664 818717 820674 823267 823458 825379 826341 826342 826556 826785 827477 ] |
||||||||||||||||||||||||||||||
|
11.42 ms (6.49%) |
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 532125 557135 675544 674333 810019 812518 411948 446624 447157 447163 455910 464960 474826 446629 474400 487341 489495 461016 510813 518848 502034 524887 525138 522594 525492 467035 483368 558286 666766 678791 775972 453100 400807 463171 466077 455436 454225 454267 474874 526843 484643 504823 826341 826785 827477 818717 823267 531321 574384 549239 466989 499112 483355 820674 818664 823458 826342 697707 653925 612273 780658 774318 733506 771336 760585 487938 467036 467043 480745 549245 678778 678790 789665 391156 474120 498722 825379 539548 533492 545012 546143 545895 547048 714159 644684 789250 795273 804274 771342 792598 738323 755499 770154 771347 732959 398539 814125 826556 817803 818659 817694 537942 531391 539605 549880 549430 707295 710453 790881 746739 748017 772875 792577 811083 731812 736000 734113 637743 466982 491790 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.55%) |
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 391156 398539 400807 411948 446624 446629 447157 447163 453100 454225 454267 455436 455910 461016 463171 464960 466077 466982 466989 467035 467036 467043 474120 474400 474826 474874 480745 483355 483368 484643 487341 487938 489495 491790 498722 499112 502034 504823 510813 518848 522594 524887 525138 525492 526843 531321 531391 532125 533492 537942 539548 539605 545012 545895 546143 547048 549239 549245 549430 549880 557135 558286 574384 612273 637743 644684 653925 666766 674333 675544 678778 678790 678791 697707 707295 710453 714159 731812 732959 733506 734113 736000 738323 746739 748017 755499 760585 770154 771336 771342 771347 772875 774318 775972 780658 789250 789665 790881 792577 792598 795273 804274 810019 811083 812518 814125 817694 817803 818659 818664 818717 820674 823267 823458 825379 826341 826342 826556 826785 827477 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"grandmother and"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бабушк"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.77%) |
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.