Query Metrics
7
Database Queries
7
Different statements
173.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.10 ms (86.01%) |
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 396001 397547 402350 415372 452303 457375 458567 458823 458826 477573 477577 477579 477581 482180 482182 484795 494717 494725 494734 522395 526411 530472 540391 542293 542309 542517 542800 542854 542860 543013 543029 543044 543073 543077 543100 543126 543149 543161 543210 543218 543227 543231 543254 543268 543270 543272 543283 543440 543454 543777 543790 546625 549148 550257 552049 552607 554117 562348 565972 566575 567138 568331 568333 574973 574986 574989 577082 577093 578130 586498 586512 586515 586524 590750 591654 600404 604588 608925 619816 622932 625655 626382 628595 628634 628671 629357 630570 630773 638159 638757 640186 641094 644910 645202 648609 660455 660836 660837 667974 671331 671351 671371 687594 688277 720820 732140 734336 734346 742515 746645 748798 750233 750260 750265 750397 750620 752104 769910 809338 812859 ] |
||||||||||||||||||||||||||||||
|
14.55 ms (8.40%) |
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 482182 543073 543029 660837 630570 742515 626382 641094 457375 667974 720820 494717 671371 522395 530472 494725 477581 543100 543254 552607 574986 578130 562348 566575 586515 619816 484795 543283 574989 660455 554117 628634 734346 752104 809338 542800 604588 458567 586512 526411 549148 543077 574973 543126 546625 687594 628595 638159 638757 750620 812859 622932 750397 644910 452303 542854 542860 543790 543013 671331 565972 590750 625655 482180 477579 397547 543227 543210 542293 542309 543149 543268 628671 608925 630773 748798 750265 750233 629357 543440 477573 458823 477577 543231 567138 543161 577082 543270 552049 577093 648609 660836 688277 640186 746645 750260 732140 769910 396001 415372 402350 568331 542517 568333 586498 591654 600404 734336 458826 540391 543777 671351 586524 494734 543044 543218 543272 550257 543454 645202 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.50%) |
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 396001 397547 402350 415372 452303 457375 458567 458823 458826 477573 477577 477579 477581 482180 482182 484795 494717 494725 494734 522395 526411 530472 540391 542293 542309 542517 542800 542854 542860 543013 543029 543044 543073 543077 543100 543126 543149 543161 543210 543218 543227 543231 543254 543268 543270 543272 543283 543440 543454 543777 543790 546625 549148 550257 552049 552607 554117 562348 565972 566575 567138 568331 568333 574973 574986 574989 577082 577093 578130 586498 586512 586515 586524 590750 591654 600404 604588 608925 619816 622932 625655 626382 628595 628634 628671 629357 630570 630773 638159 638757 640186 641094 644910 645202 648609 660455 660836 660837 667974 671331 671351 671371 687594 688277 720820 732140 734336 734346 742515 746645 748798 750233 750260 750265 750397 750620 752104 769910 809338 812859 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"arab cock"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"араб cock"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"араб cock"
]
|
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.