Query Metrics
7
Database Queries
7
Different statements
426.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.70 ms (49.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife big dildo"
]
|
||||||||||||||||||||||||||||||
|
193.42 ms (45.31%) |
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 119927 195768 381823 382578 382810 392107 398198 401809 410962 414103 415878 419998 420140 426550 427339 429881 435689 438181 440659 447597 448351 453390 454172 459403 459731 467563 469959 470473 475302 494325 502574 503738 511240 516320 522579 525112 526444 530124 535294 545445 545455 547486 548454 550550 557621 560679 561021 561954 564285 564288 564480 565621 568652 576590 583557 589120 595739 595894 597277 601778 604884 608550 614350 616072 617817 619679 623277 627147 630406 631728 638828 640418 656200 657527 669361 669376 671479 676416 678713 685526 697958 700042 701313 713788 722395 739139 739802 742364 746177 748290 749259 749697 752767 753207 757226 760319 760538 765712 766415 769015 772261 772262 776037 778659 779291 782334 784738 788360 788753 791479 792721 795390 797326 802318 803767 806764 807160 807825 824340 826507 ] |
||||||||||||||||||||||||||||||
|
12.81 ms (3.00%) |
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 119927 638828 630406 459731 760319 548454 678713 516320 382810 398198 414103 448351 454172 545455 547486 550550 560679 722395 608550 766415 749259 752767 765712 382578 470473 826507 427339 420140 415878 467563 522579 526444 545445 614350 595894 453390 429881 435689 525112 669361 669376 561021 627147 619679 426550 713788 701313 597277 640418 807160 776037 788753 753207 772261 772262 769015 748290 779291 782334 792721 806764 807825 494325 685526 401809 459403 535294 565621 623277 739139 447597 419998 440659 802318 195768 475302 564285 564288 657527 656200 676416 697958 568652 576590 631728 784738 791479 739802 616072 778659 381823 824340 557621 564480 700042 589120 601778 604884 617817 797326 803767 749697 760538 742364 746177 757226 795390 502574 392107 595739 511240 410962 469959 583557 503738 438181 671479 561954 530124 788360 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (0.69%) |
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 119927 195768 381823 382578 382810 392107 398198 401809 410962 414103 415878 419998 420140 426550 427339 429881 435689 438181 440659 447597 448351 453390 454172 459403 459731 467563 469959 470473 475302 494325 502574 503738 511240 516320 522579 525112 526444 530124 535294 545445 545455 547486 548454 550550 557621 560679 561021 561954 564285 564288 564480 565621 568652 576590 583557 589120 595739 595894 597277 601778 604884 608550 614350 616072 617817 619679 623277 627147 630406 631728 638828 640418 656200 657527 669361 669376 671479 676416 678713 685526 697958 700042 701313 713788 722395 739139 739802 742364 746177 748290 749259 749697 752767 753207 757226 760319 760538 765712 766415 769015 772261 772262 776037 778659 779291 782334 784738 788360 788753 791479 792721 795390 797326 802318 803767 806764 807160 807825 824340 826507 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен большие дилд"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен большие дилд"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.37%) |
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.