Query Metrics
7
Database Queries
7
Different statements
148.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.67 ms (79.84%) |
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 4229 220792 385264 390089 396276 403556 405831 406371 406592 406981 407103 408245 411700 415568 415737 416864 419720 425579 427561 428224 428476 430081 432034 437559 438410 442064 442319 444439 445058 445340 448176 448300 448427 449169 449613 450371 450913 452080 453417 453568 454875 460646 464644 469294 472208 474593 477069 479779 481427 482231 485307 486675 486699 488628 492247 501551 503964 510134 511798 515058 515171 516979 517180 523663 524596 524807 533047 541135 542379 546640 554883 554908 557526 564800 565066 573931 573941 580521 582603 588314 595158 597646 597840 598185 599637 600859 607704 607717 615542 618351 623364 623677 632984 639301 640706 642525 650806 652507 674688 675936 676396 692767 732236 771495 796653 808624 814910 814927 815170 815367 815559 815645 815714 818387 821179 821473 821598 822692 823425 827420 ] |
||||||||||||||||||||||||||||||
|
18.06 ms (12.15%) |
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 808624 4229 425579 460646 524807 485307 450371 477069 453417 488628 692767 599637 437559 771495 632984 416864 501551 472208 442064 515171 432034 428476 650806 406592 415568 428224 565066 403556 438410 408245 415737 815714 814927 815559 815645 454875 554908 582603 597646 607704 732236 464644 405831 411700 442319 430081 390089 814910 674688 623677 453568 516979 448300 452080 510134 474593 573941 557526 448176 469294 449613 523663 623364 220792 445058 445340 815367 821179 818387 448427 492247 486675 517180 503964 533047 511798 515058 524596 486699 573931 542379 541135 652507 676396 546640 564800 580521 598185 600859 588314 618351 642525 597840 639301 640706 419720 481427 821598 821473 823425 482231 396276 406981 406371 796653 385264 407103 427561 444439 822692 815170 827420 449169 450913 479779 554883 675936 595158 607717 615542 ] |
||||||||||||||||||||||||||||||
|
3.90 ms (2.63%) |
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 4229 220792 385264 390089 396276 403556 405831 406371 406592 406981 407103 408245 411700 415568 415737 416864 419720 425579 427561 428224 428476 430081 432034 437559 438410 442064 442319 444439 445058 445340 448176 448300 448427 449169 449613 450371 450913 452080 453417 453568 454875 460646 464644 469294 472208 474593 477069 479779 481427 482231 485307 486675 486699 488628 492247 501551 503964 510134 511798 515058 515171 516979 517180 523663 524596 524807 533047 541135 542379 546640 554883 554908 557526 564800 565066 573931 573941 580521 582603 588314 595158 597646 597840 598185 599637 600859 607704 607717 615542 618351 623364 623677 632984 639301 640706 642525 650806 652507 674688 675936 676396 692767 732236 771495 796653 808624 814910 814927 815170 815367 815559 815645 815714 818387 821179 821473 821598 822692 823425 827420 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy ass latina"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая жоп латинская"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая жоп латинская"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.23%) |
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.