Query Metrics
7
Database Queries
7
Different statements
206.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
183.24 ms (88.84%) |
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 191393 213573 326071 391740 393055 407683 415734 416296 421372 424742 429884 432700 441838 445107 445236 450802 451877 460168 463837 465958 468236 470964 470973 472641 482772 489987 490232 493754 498626 502108 502713 509556 514884 518238 518535 519034 526216 527570 531467 534270 535022 536357 536473 576641 601535 601840 604089 605308 620159 621682 621717 626890 627781 641879 644270 669275 669276 671466 675482 675547 694464 696322 699592 699594 699599 699745 703458 710833 716286 717615 721113 726657 728035 728215 733537 740616 741611 747292 748431 756321 759761 770130 771004 774273 794420 795658 799776 800242 800396 802459 803543 804619 804803 806323 806822 807600 809993 813115 815290 815470 815529 815806 815862 815948 816158 816201 817361 817526 817857 818168 819078 819410 819545 820072 821065 821399 823672 825115 827054 827648 ] |
||||||||||||||||||||||||||||||
|
13.22 ms (6.41%) |
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 669275 669276 626890 756321 416296 465958 472641 407683 470964 445236 535022 498626 463837 601535 451877 393055 415734 815290 514884 536357 536473 526216 644270 774273 728035 771004 804619 804803 806323 429884 445107 489987 518238 391740 432700 815470 815862 816201 821399 815529 818168 819078 823672 827054 817526 819410 819545 815948 817857 821065 827648 531467 534270 518535 527570 576641 671466 696322 699599 703458 721113 694464 699594 710833 675482 675547 699592 716286 717615 621682 621717 601840 605308 620159 627781 641879 794420 799776 802459 809993 813115 800242 800396 807600 803543 770130 733537 740616 747292 726657 759761 728215 741611 748431 604089 699745 795658 806822 470973 519034 213573 326071 191393 421372 441838 424742 820072 815806 817361 816158 825115 450802 490232 460168 482772 468236 493754 502108 502713 509556 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.52%) |
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 191393 213573 326071 391740 393055 407683 415734 416296 421372 424742 429884 432700 441838 445107 445236 450802 451877 460168 463837 465958 468236 470964 470973 472641 482772 489987 490232 493754 498626 502108 502713 509556 514884 518238 518535 519034 526216 527570 531467 534270 535022 536357 536473 576641 601535 601840 604089 605308 620159 621682 621717 626890 627781 641879 644270 669275 669276 671466 675482 675547 694464 696322 699592 699594 699599 699745 703458 710833 716286 717615 721113 726657 728035 728215 733537 740616 741611 747292 748431 756321 759761 770130 771004 774273 794420 795658 799776 800242 800396 802459 803543 804619 804803 806323 806822 807600 809993 813115 815290 815470 815529 815806 815862 815948 816158 816201 817361 817526 817857 818168 819078 819410 819545 820072 821065 821399 823672 825115 827054 827648 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy milf anal"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy milf анал"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy milf анал"
]
|
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.