Query Metrics
7
Database Queries
7
Different statements
194.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.45 ms (87.45%) |
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 412262 418879 419880 424329 424498 425523 426408 429089 430548 432254 437686 438844 439531 441191 442864 442918 443963 444346 446431 446735 446894 447732 448216 454993 461221 462904 465712 467721 469649 470449 473980 475595 478525 482506 482824 483239 483244 484644 485204 486020 490005 492040 492528 492921 496259 498043 500504 504718 504757 504909 505818 506816 507767 509312 512558 513215 513408 513940 514809 516659 517190 517269 519016 519560 521077 523016 523035 523212 523535 528264 528456 543536 546347 554313 561480 563441 567050 568062 568349 570700 578531 586864 587651 587855 591249 591415 591646 601231 603663 608206 609922 611477 613268 616683 617234 620699 621239 621277 622778 624840 625215 627338 628426 645918 646001 654474 671403 700949 794963 810902 ] |
||||||||||||||||||||||||||||||
|
15.55 ms (7.98%) |
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 442918 447732 438844 492040 492528 492921 486020 500504 587855 620699 570700 483244 568349 603663 617234 443963 523016 424498 516659 528264 509312 490005 506816 523035 654474 429089 454993 513408 586864 627338 794963 810902 439531 478525 432254 442864 470449 513476 496259 505818 613268 484644 519560 517269 578531 624840 418879 448216 504909 517190 523535 483239 554313 513940 482506 528456 591249 446735 519016 462904 543536 482824 430548 437686 426408 412262 504757 461221 700949 646001 591646 473980 475595 507767 521077 441191 485204 444346 513215 611477 425523 609922 467721 504718 419880 424329 446894 591415 601231 512558 561480 563441 622778 671403 446431 469649 523212 645918 546347 616683 625215 587651 621239 608206 498043 514809 568062 465712 621277 567050 628426 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.29%) |
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 412262 418879 419880 424329 424498 425523 426408 429089 430548 432254 437686 438844 439531 441191 442864 442918 443963 444346 446431 446735 446894 447732 448216 454993 461221 462904 465712 467721 469649 470449 473980 475595 478525 482506 482824 483239 483244 484644 485204 486020 490005 492040 492528 492921 496259 498043 500504 504718 504757 504909 505818 506816 507767 509312 512558 513215 513408 513940 514809 516659 517190 517269 519016 519560 521077 523016 523035 523212 523535 528264 528456 543536 546347 554313 561480 563441 567050 568062 568349 570700 578531 586864 587651 587855 591249 591415 591646 601231 603663 608206 609922 611477 613268 616683 617234 620699 621239 621277 622778 624840 625215 627338 628426 645918 646001 654474 671403 700949 794963 810902 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк парен friend"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl boy friend"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк парен friend"
]
|
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.