Query Metrics
7
Database Queries
7
Different statements
196.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.99 ms (86.54%) |
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 391654 395899 396887 398544 400807 409942 411593 411948 446624 446629 447157 447163 452232 454225 454267 455910 460340 461016 463171 464960 466077 467035 471887 474120 474400 474826 480480 483368 484643 484702 485752 486835 487933 489495 493093 498722 502034 504823 507659 511664 513333 513785 518848 518864 518869 519143 519151 519752 524887 526843 537148 539460 549245 558286 566171 580667 663391 663901 663935 664283 664793 665235 665305 665479 665513 665835 665857 666153 666766 666770 667294 667517 667607 667615 672796 678778 678790 695283 701444 714647 717700 718563 721475 724276 725341 728481 745055 746112 748379 758439 775972 781679 781709 781734 781748 784248 788276 788285 788787 788822 789363 789527 789530 789665 790596 794629 800700 800771 802409 807626 811087 816781 817410 817417 817956 824452 824934 825037 825140 ] |
||||||||||||||||||||||||||||||
|
16.55 ms (8.42%) |
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 452232 480480 460340 511664 519151 485752 513785 519143 487933 519752 484702 493093 507659 513333 518864 518869 395899 396887 398544 539460 665857 667517 701444 672796 721475 714647 781734 802409 781709 788787 789527 794629 724276 788276 745055 746112 391654 411948 446624 447157 447163 455910 464960 474826 446629 474400 489495 461016 518848 502034 524887 467035 483368 558286 666766 775972 400807 463171 466077 454225 454267 526843 484643 504823 580667 486835 817410 817956 817417 824934 816781 824452 825140 471887 566171 663391 663901 665513 664283 665835 666770 667615 695283 718563 781748 784248 789530 811087 725341 748379 788822 789363 790596 800700 800771 758439 728481 781679 788285 807626 549245 678778 678790 789665 391156 474120 498722 409942 411593 825037 537148 665479 666153 667294 667607 717700 663935 664793 665235 665305 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.34%) |
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 391654 395899 396887 398544 400807 409942 411593 411948 446624 446629 447157 447163 452232 454225 454267 455910 460340 461016 463171 464960 466077 467035 471887 474120 474400 474826 480480 483368 484643 484702 485752 486835 487933 489495 493093 498722 502034 504823 507659 511664 513333 513785 518848 518864 518869 519143 519151 519752 524887 526843 537148 539460 549245 558286 566171 580667 663391 663901 663935 664283 664793 665235 665305 665479 665513 665835 665857 666153 666766 666770 667294 667517 667607 667615 672796 678778 678790 695283 701444 714647 717700 718563 721475 724276 725341 728481 745055 746112 748379 758439 775972 781679 781709 781734 781748 784248 788276 788285 788787 788822 789363 789527 789530 789665 790596 794629 800700 800771 802409 807626 811087 816781 817410 817417 817956 824452 824934 825037 825140 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"старые бабушк"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"старые бабки"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.82%) |
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.