Query Metrics
7
Database Queries
7
Different statements
146.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.37 ms (84.00%) |
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 7161 11870 12132 95986 96636 268222 326039 360439 375949 385830 386035 387015 387922 388057 388512 388532 389797 390904 391237 392373 395598 397350 398409 400032 400821 400858 401266 402735 405699 424136 426551 429741 439343 445466 446165 446274 447588 456220 461628 476193 509799 509805 515588 515611 519697 520952 521166 522160 533972 534395 541270 541721 541864 541871 559372 562003 580592 592409 596917 600796 601789 603830 604307 605344 612699 617807 620165 630420 634100 639722 644285 644306 669074 670366 674327 678734 681280 683139 689001 703900 711907 717906 720714 724135 724272 727760 727837 728152 728424 731463 740890 741158 742315 744990 745188 750760 751512 751773 758232 764811 767217 770183 777017 777043 777059 780659 782477 788178 789664 790381 794647 795140 798572 802114 803919 814428 817154 817884 819609 820890 ] |
||||||||||||||||||||||||||||||
|
13.79 ms (9.39%) |
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 390904 426551 11870 782477 728152 740890 764811 798572 541721 388532 541270 795140 617807 268222 817884 727837 803919 387922 391237 820890 674327 580592 777059 794647 728424 744990 750760 724135 767217 720714 644285 742315 789664 400032 446274 758232 387015 790381 522160 634100 817154 819609 780659 541864 604307 375949 600796 389797 400821 534395 788178 751773 395598 326039 559372 681280 596917 727760 745188 731463 388512 400858 814428 770183 777017 388057 402735 424136 7161 639722 717906 802114 711907 541871 461628 398409 703900 439343 724272 515611 447588 405699 392373 12132 96636 445466 603830 670366 385830 533972 601789 401266 678734 683139 605344 777043 751512 644306 397350 515588 612699 476193 95986 521166 620165 429741 592409 456220 669074 630420 741158 446165 509799 519697 360439 386035 562003 689001 520952 509805 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (2.01%) |
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 7161 11870 12132 95986 96636 268222 326039 360439 375949 385830 386035 387015 387922 388057 388512 388532 389797 390904 391237 392373 395598 397350 398409 400032 400821 400858 401266 402735 405699 424136 426551 429741 439343 445466 446165 446274 447588 456220 461628 476193 509799 509805 515588 515611 519697 520952 521166 522160 533972 534395 541270 541721 541864 541871 559372 562003 580592 592409 596917 600796 601789 603830 604307 605344 612699 617807 620165 630420 634100 639722 644285 644306 669074 670366 674327 678734 681280 683139 689001 703900 711907 717906 720714 724135 724272 727760 727837 728152 728424 731463 740890 741158 742315 744990 745188 750760 751512 751773 758232 764811 767217 770183 777017 777043 777059 780659 782477 788178 789664 790381 794647 795140 798572 802114 803919 814428 817154 817884 819609 820890 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal stockings"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (1.00%) |
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.