Query Metrics
7
Database Queries
7
Different statements
175.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.48 ms (85.65%) |
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 358437 383700 385911 387320 390303 398655 400489 409179 417015 421826 428130 439662 439778 439791 439810 439856 442814 444733 452157 453343 460704 470201 470468 473846 474122 475629 476224 478378 482088 509267 516480 516483 516730 517069 518571 518762 522508 523835 524779 525604 529295 534240 537263 538006 538011 543475 549842 552285 555400 556519 557244 558898 559071 559577 562832 563173 566312 567035 568546 570972 574258 583533 587185 587846 590297 591067 596816 596929 609999 619096 619109 621716 633937 663772 668529 670357 693325 705449 710895 714911 716277 724197 725170 725198 730352 733319 733338 733375 736099 740991 741066 743829 744653 748504 758122 758397 758509 761027 764144 765218 770129 772459 777420 781995 782122 788982 795296 796957 800528 801781 803522 805355 813085 814933 817293 817886 819190 819235 820211 824459 ] |
||||||||||||||||||||||||||||||
|
15.56 ms (8.86%) |
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 801781 453343 670357 725170 385911 543475 358437 803522 817886 741066 724197 566312 596929 383700 518762 733338 764144 710895 788982 587185 470201 633937 421826 444733 552285 524779 795296 525604 557244 563173 559071 609999 538006 516483 538011 730352 820211 570972 744653 470468 668529 813085 743829 770129 733375 736099 758122 460704 387320 824459 529295 705449 716277 587846 740991 621716 473846 475629 568546 591067 428130 819190 814933 549842 733319 478378 522508 559577 562832 583533 452157 516730 482088 800528 782122 758397 765218 596816 398655 693325 781995 772459 474122 518571 556519 663772 714911 777420 796957 725198 758509 748504 761027 390303 517069 537263 523835 619109 574258 409179 417015 817293 819235 534240 555400 567035 619096 400489 509267 516480 805355 558898 439662 439810 439856 439778 439791 442814 590297 476224 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.66%) |
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 358437 383700 385911 387320 390303 398655 400489 409179 417015 421826 428130 439662 439778 439791 439810 439856 442814 444733 452157 453343 460704 470201 470468 473846 474122 475629 476224 478378 482088 509267 516480 516483 516730 517069 518571 518762 522508 523835 524779 525604 529295 534240 537263 538006 538011 543475 549842 552285 555400 556519 557244 558898 559071 559577 562832 563173 566312 567035 568546 570972 574258 583533 587185 587846 590297 591067 596816 596929 609999 619096 619109 621716 633937 663772 668529 670357 693325 705449 710895 714911 716277 724197 725170 725198 730352 733319 733338 733375 736099 740991 741066 743829 744653 748504 758122 758397 758509 761027 764144 765218 770129 772459 777420 781995 782122 788982 795296 796957 800528 801781 803522 805355 813085 814933 817293 817886 819190 819235 820211 824459 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal mature maid"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал mature горничн"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал mature горничн"
]
|
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.