Query Metrics
7
Database Queries
7
Different statements
150.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.26 ms (83.14%) |
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 6699 8028 73571 181994 203946 237982 271293 323845 384881 385360 387944 390680 390747 395587 405054 412089 417220 418943 419590 421802 425061 427980 430789 432534 438312 442983 443873 445278 446117 455182 462821 462826 466174 467182 468178 469703 474140 474564 475427 476131 482975 485079 491423 491453 500434 500436 503663 503682 504184 507154 510728 515601 515624 515692 516731 522587 522599 522620 522744 534953 537411 538973 540063 544591 554791 555652 560640 563495 567461 567872 571743 585524 587504 588334 590357 591087 595767 596324 599565 600814 600838 601071 603296 604430 605999 609402 620847 623606 678838 680562 680754 689318 689755 700222 701223 701753 706021 712718 716199 718750 733048 743946 751012 760004 785920 789790 789874 797247 800572 803327 803534 805124 810646 813904 815127 817236 825256 825555 827571 828789 ] |
||||||||||||||||||||||||||||||
|
14.73 ms (9.78%) |
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 384881 522587 476131 789874 446117 504184 181994 387944 815127 706021 680754 712718 585524 810646 751012 701223 395587 412089 474564 466174 522620 482975 828789 442983 425061 813904 797247 485079 405054 419590 537411 567872 555652 563495 603296 600814 805124 700222 716199 421802 432534 455182 385360 825256 203946 6699 534953 522599 469703 680562 689318 560640 601071 620847 803534 733048 623606 427980 491453 554791 678838 604430 588334 789790 743946 605999 800572 443873 475427 430789 515601 538973 462821 689755 701753 827571 323845 8028 467182 417220 390747 418943 462826 522744 515692 567461 544591 595767 596324 438312 503663 271293 825555 468178 500434 540063 599565 590357 587504 785920 237982 390680 516731 760004 817236 73571 507154 718750 503682 500436 515624 445278 491423 510728 474140 571743 600838 591087 609402 803327 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.76%) |
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 6699 8028 73571 181994 203946 237982 271293 323845 384881 385360 387944 390680 390747 395587 405054 412089 417220 418943 419590 421802 425061 427980 430789 432534 438312 442983 443873 445278 446117 455182 462821 462826 466174 467182 468178 469703 474140 474564 475427 476131 482975 485079 491423 491453 500434 500436 503663 503682 504184 507154 510728 515601 515624 515692 516731 522587 522599 522620 522744 534953 537411 538973 540063 544591 554791 555652 560640 563495 567461 567872 571743 585524 587504 588334 590357 591087 595767 596324 599565 600814 600838 601071 603296 604430 605999 609402 620847 623606 678838 680562 680754 689318 689755 700222 701223 701753 706021 712718 716199 718750 733048 743946 751012 760004 785920 789790 789874 797247 800572 803327 803534 805124 810646 813904 815127 817236 825256 825555 827571 828789 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"office girl"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секретарш девушк"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.16%) |
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.