Query Metrics
7
Database Queries
7
Different statements
182.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.87 ms (88.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 54387 98951 131517 190891 359456 383250 386700 386913 388894 389067 390205 393391 393462 404429 407515 408056 411804 413108 413175 414850 417452 418942 425495 425638 425971 428822 432355 435487 437344 440947 448352 450145 450645 452335 453444 453660 454718 456437 463775 464018 468821 469484 474457 475253 484285 489138 490890 526219 533821 555091 557141 559596 567415 575022 581600 599595 609806 615009 617788 639775 641683 643086 643378 644253 644270 645879 648872 693348 699059 719086 719814 720618 721184 729253 730244 730806 733998 738329 741891 745172 748733 749181 755396 755868 758922 779822 780536 786545 793484 793747 795799 797580 798241 799826 802534 803088 803249 804606 810063 810148 811853 813794 815041 815288 816394 817088 817357 819112 819988 820046 820119 821166 824522 825906 825986 826163 826559 828509 ] |
||||||||||||||||||||||||||||||
|
11.49 ms (6.31%) |
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 533821 557141 575022 719814 639775 779822 799826 733998 748733 758922 617788 413108 816394 190891 408056 393391 643086 131517 824522 821166 825986 780536 755868 804606 786545 810063 454718 699059 720618 797580 730244 464018 645879 489138 417452 730806 388894 810148 414850 411804 453660 615009 98951 475253 450645 440947 815288 826163 813794 559596 644253 803249 798241 741891 729253 609806 393462 490890 721184 425495 448352 383250 452335 453444 643378 359456 425971 474457 54387 428822 825906 793747 820119 817088 819988 820046 819112 648872 693348 769936 738329 755396 815041 526219 555091 432355 435487 404429 390205 425638 468821 581600 469484 644270 749181 437344 456437 599595 567415 803088 407515 826559 817357 828509 719086 795799 745172 811853 762279 641683 386913 389067 793484 802534 386700 413175 418942 463775 484285 450145 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.43%) |
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 54387 98951 131517 190891 359456 383250 386700 386913 388894 389067 390205 393391 393462 404429 407515 408056 411804 413108 413175 414850 417452 418942 425495 425638 425971 428822 432355 435487 437344 440947 448352 450145 450645 452335 453444 453660 454718 456437 463775 464018 468821 469484 474457 475253 484285 489138 490890 526219 533821 555091 557141 559596 567415 575022 581600 599595 609806 615009 617788 639775 641683 643086 643378 644253 644270 645879 648872 693348 699059 719086 719814 720618 721184 729253 730244 730806 733998 738329 741891 745172 748733 749181 755396 755868 758922 779822 780536 786545 793484 793747 795799 797580 798241 799826 802534 803088 803249 804606 810063 810148 811853 813794 815041 815288 816394 817088 817357 819112 819988 820046 820119 821166 824522 825906 825986 826163 826559 828509 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blow job milf"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс milf"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс milf"
]
|
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.