Query Metrics
7
Database Queries
7
Different statements
171.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.46 ms (85.53%) |
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 209373 386568 402085 430290 430949 431673 433883 439852 444938 446331 446656 449273 449304 461862 462402 464273 468756 469675 472285 474809 475343 475714 479277 482073 489544 489623 490694 492484 500692 501581 505528 507487 507879 513645 513724 513769 515803 521877 523398 524526 536058 538214 546002 546737 550716 551616 551619 551972 552792 552798 554307 558562 559077 559085 559145 559501 560112 560469 561418 561712 562315 564420 567391 572134 572956 574881 575053 575122 575443 575702 575803 576037 576062 576324 576445 578293 579200 580672 581291 586463 589134 593431 595579 597528 599559 601317 601358 604619 613305 619509 623312 624864 653496 654936 670965 679355 680151 681441 683802 684088 694119 714452 722805 730461 730788 736645 737098 743053 760629 766302 767956 775780 786762 787616 788289 801942 810701 818936 821745 827956 ] |
||||||||||||||||||||||||||||||
|
13.68 ms (7.99%) |
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 523398 515803 464273 562315 559145 575803 576324 579200 680151 653496 684088 681441 560112 576062 597528 601358 624864 589134 601317 810701 730788 730461 722805 446331 469675 475714 209373 431673 468756 430949 482073 524526 513724 489544 490694 521877 538214 827956 683802 743053 786762 475343 386568 444938 430290 433883 818936 821745 449304 474809 479277 449273 461862 462402 472285 492484 446656 501581 507487 513769 505528 536058 500692 507879 513645 489623 550716 551619 554307 559077 559085 559501 572956 575122 575443 576445 546737 551616 551972 552792 560469 572134 574881 575053 580672 581291 558562 561418 564420 575702 576037 670965 679355 694119 654936 714452 546002 552798 561712 567391 578293 604619 623312 586463 593431 599559 619509 595579 775780 788289 801942 737098 760629 736645 767956 766302 613305 787616 402085 439852 ] |
||||||||||||||||||||||||||||||
|
3.40 ms (1.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые teens pussy"
]
|
||||||||||||||||||||||||||||||
|
2.69 ms (1.57%) |
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 209373 386568 402085 430290 430949 431673 433883 439852 444938 446331 446656 449273 449304 461862 462402 464273 468756 469675 472285 474809 475343 475714 479277 482073 489544 489623 490694 492484 500692 501581 505528 507487 507879 513645 513724 513769 515803 521877 523398 524526 536058 538214 546002 546737 550716 551616 551619 551972 552792 552798 554307 558562 559077 559085 559145 559501 560112 560469 561418 561712 562315 564420 567391 572134 572956 574881 575053 575122 575443 575702 575803 576037 576062 576324 576445 578293 579200 580672 581291 586463 589134 593431 595579 597528 599559 601317 601358 604619 613305 619509 623312 624864 653496 654936 670965 679355 680151 681441 683802 684088 694119 714452 722805 730461 730788 736645 737098 743053 760629 766302 767956 775780 786762 787616 788289 801942 810701 818936 821745 827956 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny teens pussy"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые teens pussy"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.89%) |
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.