Query Metrics
7
Database Queries
7
Different statements
213.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
180.80 ms (84.65%) |
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 388341 389966 395702 396600 396742 406935 409506 409894 412081 412911 414929 415004 415005 416820 417344 417897 417898 419777 420190 421093 423612 426152 428174 434324 435624 441049 442994 444322 444654 445398 445945 447315 447493 454210 454270 461275 462319 463803 464162 464499 467875 467882 469193 471811 473539 475904 480429 483906 484065 486182 491403 496063 496074 496835 500288 511372 512491 512984 513660 518823 520801 520909 525178 525446 526502 527428 538817 539220 544473 548414 550864 553436 557025 557228 559787 560954 565539 569303 573213 580139 585920 589876 590724 592440 601617 602056 607355 610138 611315 614789 615919 620438 623564 630649 640260 641485 647885 663353 670952 680536 680934 686093 688581 708519 710096 716321 717318 720333 725447 727334 729759 743119 773884 801206 802824 803782 804269 805385 810978 820686 ] |
||||||||||||||||||||||||||||||
|
21.97 ms (10.28%) |
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 434324 467875 471811 417898 395702 412911 496063 469193 447493 426152 389966 717318 557025 560954 663353 525446 573213 710096 589876 602056 716321 421093 743119 773884 590724 614789 801206 641485 729759 454210 473539 416820 435624 441049 428174 445398 445945 463803 464499 491403 513660 512984 526502 538817 484065 550864 559787 611315 467882 415004 423612 417897 419777 454270 496074 520801 496835 412081 480429 610138 553436 557228 680934 686093 680536 720333 620438 802824 803782 804269 725447 805385 483906 548414 670952 630649 388341 461275 525178 539220 615919 601617 623564 640260 727334 708519 810978 444654 520909 396600 406935 415005 420190 409894 414929 442994 500288 527428 464162 486182 569303 565539 580139 544473 688581 647885 592440 607355 409506 396742 462319 417344 447315 475904 511372 512491 444322 820686 518823 585920 ] |
||||||||||||||||||||||||||||||
|
3.47 ms (1.62%) |
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 388341 389966 395702 396600 396742 406935 409506 409894 412081 412911 414929 415004 415005 416820 417344 417897 417898 419777 420190 421093 423612 426152 428174 434324 435624 441049 442994 444322 444654 445398 445945 447315 447493 454210 454270 461275 462319 463803 464162 464499 467875 467882 469193 471811 473539 475904 480429 483906 484065 486182 491403 496063 496074 496835 500288 511372 512491 512984 513660 518823 520801 520909 525178 525446 526502 527428 538817 539220 544473 548414 550864 553436 557025 557228 559787 560954 565539 569303 573213 580139 585920 589876 590724 592440 601617 602056 607355 610138 611315 614789 615919 620438 623564 630649 640260 641485 647885 663353 670952 680536 680934 686093 688581 708519 710096 716321 717318 720333 725447 727334 729759 743119 773884 801206 802824 803782 804269 805385 810978 820686 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"extreme hairy pussy"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор волосатая pussy"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"хардкор волосатая pussy"
]
|
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.