Query Metrics
7
Database Queries
7
Different statements
386.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.42 ms (54.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"caught минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
150.01 ms (38.83%) |
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 198001 393105 401031 401956 410559 411765 420261 425814 425828 426461 429261 438415 438708 441018 443306 447735 453061 454085 455076 456497 457023 458803 460447 461818 463628 463699 470260 476329 477120 482990 484213 497180 502173 517277 519885 522295 524404 534220 540233 542185 546690 554525 560002 562085 562732 564049 569135 571465 571474 579189 579209 585246 588272 593741 599677 605366 605507 607103 613390 618234 624081 626212 626843 633666 633832 638564 651214 662213 665220 665359 665503 669206 671312 673572 680754 685106 689056 696313 699796 699824 701904 705116 706759 706997 711590 714571 715559 720443 721469 721598 724029 725160 737037 738001 741523 741859 743406 744431 745072 752800 762065 764094 764100 764426 764703 773294 774349 775249 776491 778714 784794 785713 788627 790016 793219 793494 802110 804825 805387 808701 ] |
||||||||||||||||||||||||||||||
|
16.17 ms (4.19%) |
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 546690 562085 569135 720443 665359 689056 721598 662213 685106 706997 585246 605366 605507 624081 626843 785713 793219 724029 737037 745072 752800 764100 741859 741523 773294 802110 425814 458803 461818 599677 633666 410559 638564 743406 447735 420261 429261 438415 457023 562732 579209 651214 579189 593741 618234 711590 411765 463628 425828 198001 463699 460447 517277 524404 665220 633832 790016 738001 454085 393105 401031 426461 484213 571465 571474 805387 476329 477120 455076 534220 497180 696313 438708 443306 453061 441018 522295 482990 502173 470260 542185 564049 554525 669206 671312 699796 706759 705116 665503 673572 680754 699824 701904 721469 626212 613390 607103 784794 775249 778714 793494 808701 725160 744431 804825 764703 764094 774349 762065 764426 714571 776491 788627 456497 540233 560002 519885 401956 715559 588272 ] |
||||||||||||||||||||||||||||||
|
3.49 ms (0.90%) |
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 198001 393105 401031 401956 410559 411765 420261 425814 425828 426461 429261 438415 438708 441018 443306 447735 453061 454085 455076 456497 457023 458803 460447 461818 463628 463699 470260 476329 477120 482990 484213 497180 502173 517277 519885 522295 524404 534220 540233 542185 546690 554525 560002 562085 562732 564049 569135 571465 571474 579189 579209 585246 588272 593741 599677 605366 605507 607103 613390 618234 624081 626212 626843 633666 633832 638564 651214 662213 665220 665359 665503 669206 671312 673572 680754 685106 689056 696313 699796 699824 701904 705116 706759 706997 711590 714571 715559 720443 721469 721598 724029 725160 737037 738001 741523 741859 743406 744431 745072 752800 762065 764094 764100 764426 764703 773294 774349 775249 776491 778714 784794 785713 788627 790016 793219 793494 802110 804825 805387 808701 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"caught blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"caught минет оральн секс"
]
|
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.