Query Metrics
7
Database Queries
7
Different statements
188.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.73 ms (87.41%) |
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 490807 511417 522377 522885 532067 532072 532082 537697 537714 538847 541339 541624 541636 541693 542198 542470 542477 542481 542488 543010 544264 544276 544291 544294 544316 544325 544333 544335 544342 544359 544380 544575 544591 545765 547259 547264 547321 547654 548271 548294 549264 549288 549291 549320 549323 549325 549326 549334 549339 549347 549364 549365 549426 549875 550627 551706 551711 551953 554900 556985 559118 560084 562609 563538 566532 566689 566860 570780 570800 570809 570813 570826 571020 572564 572573 572577 572586 572598 572602 572621 572631 574222 574232 574279 577118 579910 579921 579930 580829 583841 583899 586826 590932 592472 599698 603279 606757 612288 628324 629942 641658 642816 649989 651210 668438 668441 668465 668941 676599 681076 684202 685472 687098 703234 705290 705298 707274 716177 780719 790088 ] |
||||||||||||||||||||||||||||||
|
13.31 ms (7.07%) |
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 560084 687098 549875 592472 599698 629942 668441 544359 572598 551953 572564 544342 549426 685472 532082 562609 570780 707274 612288 549264 544264 548271 551706 549347 583899 586826 549291 537714 668438 705298 549325 544575 549323 544276 556985 570813 649989 590932 676599 543010 559118 542488 544591 549339 549365 571020 547654 572621 577118 579921 549288 572631 541693 566860 572602 532072 542481 544333 544335 572586 550627 579930 703234 572577 579910 641658 537697 780719 548294 549364 574232 606757 538847 580829 570809 545765 490807 547321 563538 681076 541636 628324 511417 566532 544316 544294 651210 668941 668465 603279 542198 544380 551711 547264 570800 547259 684202 570826 583841 542470 572573 549320 541624 544325 574279 554900 790088 541339 542477 549334 532067 522885 549326 574222 566689 642816 716177 705290 522377 544291 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.64%) |
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 490807 511417 522377 522885 532067 532072 532082 537697 537714 538847 541339 541624 541636 541693 542198 542470 542477 542481 542488 543010 544264 544276 544291 544294 544316 544325 544333 544335 544342 544359 544380 544575 544591 545765 547259 547264 547321 547654 548271 548294 549264 549288 549291 549320 549323 549325 549326 549334 549339 549347 549364 549365 549426 549875 550627 551706 551711 551953 554900 556985 559118 560084 562609 563538 566532 566689 566860 570780 570800 570809 570813 570826 571020 572564 572573 572577 572586 572598 572602 572621 572631 574222 574232 574279 577118 579910 579921 579930 580829 583841 583899 586826 590932 592472 599698 603279 606757 612288 628324 629942 641658 642816 649989 651210 668438 668441 668465 668941 676599 681076 684202 685472 687098 703234 705290 705298 707274 716177 780719 790088 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex films"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс фильм"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.84%) |
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.