Query Metrics
7
Database Queries
7
Different statements
212.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.17 ms (82.53%) |
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 404766 405272 415577 416965 419988 420262 422299 424527 432081 435664 442042 443833 451004 451965 455438 457629 465358 465834 466157 469424 473725 474820 477230 478332 478458 479196 479811 484689 485622 493160 494702 494983 500699 507973 509543 512527 514644 514997 515633 517414 520597 521131 521653 522403 523995 524528 525693 525966 526811 527614 536371 541242 542941 543419 549246 549248 549857 550436 550853 551487 551913 554370 559121 561071 561576 561853 561888 565178 566248 566536 567148 574396 575794 576286 576308 576653 580952 589642 589825 590884 591135 595799 596693 596904 597002 597042 597533 598263 601699 603255 603971 608416 610606 613171 615938 615975 616800 617597 617674 619038 619539 620052 621228 621988 623678 624030 625001 625870 625884 649123 652263 652893 653459 654322 654352 659216 659328 663421 667233 759691 ] |
||||||||||||||||||||||||||||||
|
23.79 ms (11.21%) |
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 422299 465358 473725 451004 484689 493160 485622 615975 442042 416965 451965 479811 542941 565178 549857 561071 759691 415577 478332 455438 465834 520597 525966 509543 591135 549248 576308 494702 435664 474820 550853 478458 527614 659328 549246 526811 443833 457629 521653 515633 541242 561888 559121 580952 596693 432081 525693 574396 663421 596904 601699 466157 514644 536371 610606 625001 479196 595799 654352 649123 667233 597042 620052 589825 597533 616800 597002 619038 514997 575794 652893 654322 419988 424527 507973 517414 494983 561853 566248 576286 566536 652263 653459 659216 624030 590884 603971 625870 608416 613171 615938 617597 621988 420262 404766 405272 469424 500699 521131 550436 551487 551913 576653 554370 567148 598263 623678 589642 621228 625884 603255 617674 619539 477230 522403 524528 512527 523995 561576 543419 ] |
||||||||||||||||||||||||||||||
|
5.57 ms (2.63%) |
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 404766 405272 415577 416965 419988 420262 422299 424527 432081 435664 442042 443833 451004 451965 455438 457629 465358 465834 466157 469424 473725 474820 477230 478332 478458 479196 479811 484689 485622 493160 494702 494983 500699 507973 509543 512527 514644 514997 515633 517414 520597 521131 521653 522403 523995 524528 525693 525966 526811 527614 536371 541242 542941 543419 549246 549248 549857 550436 550853 551487 551913 554370 559121 561071 561576 561853 561888 565178 566248 566536 567148 574396 575794 576286 576308 576653 580952 589642 589825 590884 591135 595799 596693 596904 597002 597042 597533 598263 601699 603255 603971 608416 610606 613171 615938 615975 616800 617597 617674 619038 619539 620052 621228 621988 623678 624030 625001 625870 625884 649123 652263 652893 653459 654322 654352 659216 659328 663421 667233 759691 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"язык поцелуй"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"язык поцел"
]
|
||||||||||||||||||||||||||||||
|
1.75 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.