Query Metrics
7
Database Queries
7
Different statements
180.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.93 ms (85.34%) |
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 13492 190925 247347 324395 388770 390569 401053 401957 404777 405505 407876 411189 415734 417042 422666 425014 426367 430348 430377 435483 437676 443594 443765 445620 448733 452163 454373 454886 455972 457668 465611 466807 471881 473247 476327 478814 478949 482239 484205 484624 486081 487442 493097 493539 503569 503895 504345 505809 509317 511399 513090 516320 518940 519016 523901 526268 526421 527980 529137 536391 543854 547928 550137 554911 556816 556817 558077 558835 559845 561380 563014 566781 578412 580971 581737 587161 588647 590303 592438 594126 594243 599997 600023 600239 600432 601052 604156 604782 604885 604896 632267 644265 644371 666830 687862 697078 717731 717862 726625 726956 727087 728188 728232 728444 737473 741615 759855 759890 759896 770546 771251 775774 775793 796243 796250 801382 803488 803495 805008 814515 ] |
||||||||||||||||||||||||||||||
|
17.03 ms (9.44%) |
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 717731 687862 558835 594126 600023 604896 604156 604885 632267 644265 587161 599997 600432 594243 600239 601052 805008 775774 775793 803488 727087 737473 759896 801382 759890 726956 728444 741615 771251 726625 759855 473247 190925 407876 437676 476327 504345 529137 486081 493539 425014 516320 443765 519016 518940 559845 543854 563014 566781 411189 523901 493097 484624 13492 390569 401053 404777 405505 814515 457668 452163 448733 454373 482239 505809 526421 465611 466807 556817 558077 580971 547928 550137 578412 717862 697078 556816 561380 581737 588647 604782 590303 592438 796250 728232 770546 644371 401957 443594 478949 417042 422666 426367 247347 430377 478814 430348 435483 445620 509317 511399 484205 503895 536391 487442 527980 415734 454886 388770 471881 503569 526268 455972 513090 554911 324395 666830 796243 803495 728188 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.48%) |
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 13492 190925 247347 324395 388770 390569 401053 401957 404777 405505 407876 411189 415734 417042 422666 425014 426367 430348 430377 435483 437676 443594 443765 445620 448733 452163 454373 454886 455972 457668 465611 466807 471881 473247 476327 478814 478949 482239 484205 484624 486081 487442 493097 493539 503569 503895 504345 505809 509317 511399 513090 516320 518940 519016 523901 526268 526421 527980 529137 536391 543854 547928 550137 554911 556816 556817 558077 558835 559845 561380 563014 566781 578412 580971 581737 587161 588647 590303 592438 594126 594243 599997 600023 600239 600432 601052 604156 604782 604885 604896 632267 644265 644371 666830 687862 697078 717731 717862 726625 726956 727087 728188 728232 728444 737473 741615 759855 759890 759896 770546 771251 775774 775793 796243 796250 801382 803488 803495 805008 814515 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"грудаст зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"дал грудастой зрелке"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"грудаст зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.