Query Metrics
7
Database Queries
7
Different statements
172.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.76 ms (82.16%) |
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 130126 385003 391049 392086 395739 395755 397329 398613 399456 399515 400434 401227 401440 402027 411052 418043 418383 421441 425656 426194 427089 427282 428979 434888 437241 437252 437311 437367 440702 448625 449849 449907 452761 453110 454371 454860 454870 457113 457664 457694 462508 463770 465507 472508 472514 472883 477317 479991 489395 489668 490155 502791 503462 503949 504622 510586 512679 514769 516125 517042 517293 519828 520603 520675 523487 524244 524277 524642 525141 525183 526037 526320 526615 539700 540311 540623 541913 547859 562182 563276 565004 571343 577083 579488 581713 588378 588559 594108 597925 598178 600684 603043 616674 620299 625135 626030 644194 659197 667791 682071 684304 688105 699056 722501 732744 738013 744285 756973 764698 771008 784567 785355 785516 788428 795234 797879 801098 809891 813471 827909 ] |
||||||||||||||||||||||||||||||
|
21.92 ms (12.70%) |
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 519828 547859 594108 644194 801098 756973 785355 454371 477317 385003 391049 517042 732744 392086 827909 540311 539700 563276 795234 813471 771008 785516 398613 437252 426194 620299 399515 130126 472514 699056 797879 400434 401227 437241 465507 524277 472508 577083 688105 428979 479991 462508 454860 454870 524244 395739 399456 520603 526320 504622 503949 540623 463770 667791 722501 588559 788428 744285 401440 523487 517293 526037 425656 440702 427282 449907 453110 457664 457113 489395 503462 541913 579488 571343 684304 682071 562182 597925 603043 616674 427089 418043 452761 418383 434888 457694 502791 516125 512679 526615 524642 525141 411052 437367 565004 659197 600684 625135 809891 395755 514769 525183 489668 490155 421441 448625 449849 472883 510586 520675 581713 598178 588378 626030 784567 738013 764698 402027 437311 397329 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.34%) |
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 130126 385003 391049 392086 395739 395755 397329 398613 399456 399515 400434 401227 401440 402027 411052 418043 418383 421441 425656 426194 427089 427282 428979 434888 437241 437252 437311 437367 440702 448625 449849 449907 452761 453110 454371 454860 454870 457113 457664 457694 462508 463770 465507 472508 472514 472883 477317 479991 489395 489668 490155 502791 503462 503949 504622 510586 512679 514769 516125 517042 517293 519828 520603 520675 523487 524244 524277 524642 525141 525183 526037 526320 526615 539700 540311 540623 541913 547859 562182 563276 565004 571343 577083 579488 581713 588378 588559 594108 597925 598178 600684 603043 616674 620299 625135 626030 644194 659197 667791 682071 684304 688105 699056 722501 732744 738013 744285 756973 764698 771008 784567 785355 785516 788428 795234 797879 801098 809891 813471 827909 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex daughter"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс daughter"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс daughter"
]
|
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.