Query Metrics
7
Database Queries
7
Different statements
249.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
227.27 ms (91.17%) |
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 88760 191075 210106 382321 383288 384924 385148 397948 398618 407830 438560 446134 454114 456945 463285 465479 495204 503979 536324 543385 547030 550272 555175 556757 558000 564214 575259 577268 579809 583224 584027 584048 587205 588337 592238 592285 593415 594450 607035 607435 607578 607703 610118 627531 630761 639647 640841 650854 653479 656487 657112 659446 663415 663960 665081 673196 674309 692924 700829 700908 705352 711566 716216 716219 718155 718271 724494 726650 728536 728601 731260 735897 736472 737895 738283 739644 739935 741088 744224 745865 747056 747290 749592 749598 749614 749654 756358 759973 760729 760768 761234 766608 766769 772882 773225 775859 776656 777097 785697 789380 789535 789604 791671 795651 797337 797521 800080 801390 801739 802500 802574 804126 805360 808705 808966 809087 809555 812404 812475 812886 ] |
||||||||||||||||||||||||||||||
|
12.03 ms (4.83%) |
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 577268 584027 547030 556757 656487 657112 716216 700829 700908 692924 705352 564214 584048 630761 588337 607435 607578 593415 592238 776656 785697 789380 802500 805360 808966 737895 739644 749592 797337 800080 804126 809555 731260 745865 724494 760729 738283 749654 759973 766608 610118 627531 718155 775859 801739 802574 382321 463285 438560 384924 385148 383288 210106 191075 88760 397948 398618 407830 446134 456945 454114 465479 536324 495204 503979 543385 579809 583224 550272 558000 674309 711566 716219 663415 665081 673196 718271 650854 653479 659446 663960 555175 575259 607035 594450 587205 592285 607703 639647 640841 777097 789535 789604 791671 795651 797521 812404 741088 744224 749598 756358 760768 772882 801390 808705 809087 812475 812886 747290 736472 739935 747056 766769 773225 735897 761234 726650 728536 728601 749614 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.15%) |
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 88760 191075 210106 382321 383288 384924 385148 397948 398618 407830 438560 446134 454114 456945 463285 465479 495204 503979 536324 543385 547030 550272 555175 556757 558000 564214 575259 577268 579809 583224 584027 584048 587205 588337 592238 592285 593415 594450 607035 607435 607578 607703 610118 627531 630761 639647 640841 650854 653479 656487 657112 659446 663415 663960 665081 673196 674309 692924 700829 700908 705352 711566 716216 716219 718155 718271 724494 726650 728536 728601 731260 735897 736472 737895 738283 739644 739935 741088 744224 745865 747056 747290 749592 749598 749614 749654 756358 759973 760729 760768 761234 766608 766769 772882 773225 775859 776656 777097 785697 789380 789535 789604 791671 795651 797337 797521 800080 801390 801739 802500 802574 804126 805360 808705 808966 809087 809555 812404 812475 812886 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пышн"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пышной"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.62%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.33 ms (0.53%) |
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.