Query Metrics
7
Database Queries
7
Different statements
176.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.47 ms (87.05%) |
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 309449 382049 382060 384998 397481 399926 401842 406312 411838 412183 414729 426085 430476 445542 447143 449060 452648 459192 476138 476578 486674 492247 519688 527231 527464 530836 531085 532166 535045 536640 537673 541434 542859 559091 580647 580765 585135 585753 587729 602443 603220 607403 608441 608629 610284 617408 620160 623869 626838 627018 628114 629304 634770 637085 642556 645001 647328 649975 650532 653601 653630 653865 654200 663547 664212 669574 670239 672999 677323 684048 703472 716969 720245 720291 720340 720394 720840 720882 724934 726301 730299 731323 731480 732003 732733 733589 734481 742135 747234 755759 765648 767859 768879 770546 770884 775261 775794 788315 792560 793376 794265 796078 799653 806160 809302 810668 811040 813873 814659 814822 815064 815374 815442 815473 815483 815748 818181 821844 825122 825561 ] |
||||||||||||||||||||||||||||||
|
13.38 ms (7.59%) |
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 603220 770546 806160 755759 825122 653630 459192 747234 607403 775794 720394 810668 720340 731323 821844 406312 559091 815442 542859 770884 730299 732003 645001 814822 815483 792560 447143 382060 412183 492247 653865 654200 629304 608441 742135 649975 818181 519688 672999 587729 799653 768879 825561 527231 653601 663547 626838 703472 775261 809302 716969 452648 426085 796078 414729 476138 720840 642556 815064 794265 726301 535045 397481 793376 536640 669574 811040 617408 399926 813873 720882 734481 815473 537673 532166 684048 664212 620160 814659 486674 637085 724934 733589 765648 788315 531085 650532 602443 623869 767859 720291 411838 610284 627018 476578 634770 731480 309449 430476 580765 580647 677323 732733 585753 445542 449060 670239 608629 530836 647328 382049 585135 815748 541434 384998 815374 527464 720245 628114 401842 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.48%) |
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 309449 382049 382060 384998 397481 399926 401842 406312 411838 412183 414729 426085 430476 445542 447143 449060 452648 459192 476138 476578 486674 492247 519688 527231 527464 530836 531085 532166 535045 536640 537673 541434 542859 559091 580647 580765 585135 585753 587729 602443 603220 607403 608441 608629 610284 617408 620160 623869 626838 627018 628114 629304 634770 637085 642556 645001 647328 649975 650532 653601 653630 653865 654200 663547 664212 669574 670239 672999 677323 684048 703472 716969 720245 720291 720340 720394 720840 720882 724934 726301 730299 731323 731480 732003 732733 733589 734481 742135 747234 755759 765648 767859 768879 770546 770884 775261 775794 788315 792560 793376 794265 796078 799653 806160 809302 810668 811040 813873 814659 814822 815064 815374 815442 815473 815483 815748 818181 821844 825122 825561 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina threesome"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.