Query Metrics
7
Database Queries
7
Different statements
188.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.25 ms (86.39%) |
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 42536 60096 149815 391096 391186 396326 396337 400843 403250 411880 417265 417660 418304 418305 418433 419143 420027 420194 421411 422747 423068 423688 425422 429025 429698 432161 434861 435948 444974 446882 447324 454590 456132 457255 457264 457785 458382 459234 460022 467744 473754 475250 475695 494432 495666 497453 499027 517685 521048 522190 527113 530238 533968 534922 535632 550419 550996 552827 554337 554343 557685 558576 559855 563880 566488 567835 568869 571813 574940 578293 585388 586639 586648 591911 594441 599116 599820 600540 600627 603632 609992 614597 619458 623501 623955 630716 630731 648598 649384 651544 658110 658208 658222 658224 658225 658226 671837 672261 684183 686082 711286 716843 718309 730906 731484 748676 748748 750449 762296 762382 765710 768123 771807 771823 774690 789831 800367 812879 817757 827832 ] |
||||||||||||||||||||||||||||||
|
15.20 ms (8.04%) |
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 517685 434861 457785 568869 423068 800367 420194 521048 435948 554343 762382 812879 447324 494432 454590 550419 658224 599820 774690 731484 768123 711286 497453 658222 658226 630716 651544 716843 574940 418433 419143 42536 421411 60096 671837 623955 425422 750449 396326 429698 396337 765710 586639 630731 550996 619458 522190 558576 459234 563880 422747 730906 495666 567835 585388 609992 771807 400843 391096 817757 429025 789831 599116 456132 552827 614597 420027 591911 527113 827832 458382 658110 578293 417660 467744 418304 417265 557685 648598 418305 603632 649384 475695 457255 554337 672261 423688 403250 533968 594441 475250 684183 457264 623501 432161 473754 658208 718309 658225 748676 446882 460022 149815 559855 748748 762296 600627 499027 571813 586648 600540 535632 530238 534922 686082 391186 444974 411880 566488 771823 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (1.79%) |
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 42536 60096 149815 391096 391186 396326 396337 400843 403250 411880 417265 417660 418304 418305 418433 419143 420027 420194 421411 422747 423068 423688 425422 429025 429698 432161 434861 435948 444974 446882 447324 454590 456132 457255 457264 457785 458382 459234 460022 467744 473754 475250 475695 494432 495666 497453 499027 517685 521048 522190 527113 530238 533968 534922 535632 550419 550996 552827 554337 554343 557685 558576 559855 563880 566488 567835 568869 571813 574940 578293 585388 586639 586648 591911 594441 599116 599820 600540 600627 603632 609992 614597 619458 623501 623955 630716 630731 648598 649384 651544 658110 658208 658222 658224 658225 658226 671837 672261 684183 686082 711286 716843 718309 730906 731484 748676 748748 750449 762296 762382 765710 768123 771807 771823 774690 789831 800367 812879 817757 827832 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск азиатк секс"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur asian sex"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск азиатк секс"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.85%) |
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.