Query Metrics
7
Database Queries
7
Different statements
185.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.64 ms (86.79%) |
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 12897 390071 466394 468209 506474 543750 546730 547649 548660 549292 549329 550564 551619 551952 552798 555788 557228 558469 558573 559501 562104 564420 564461 566925 568051 569681 569906 569913 570061 570207 570265 570525 570919 571390 572134 572378 572508 573286 573290 573598 574978 575053 575122 575485 575702 576109 576276 576330 576392 579596 583641 593915 595478 595690 598150 602638 621733 622626 631299 636270 651909 656965 657697 658556 658713 659113 659274 659721 660562 661540 663365 665258 668865 670817 671115 671325 672743 674778 675813 679361 688403 714452 719108 723487 724750 726449 728995 730570 730649 733911 734345 736345 737386 743086 743955 744796 758525 766563 775051 775595 779915 780485 790242 794524 795585 799608 804783 810591 812088 812143 814578 815766 817495 818433 818936 820453 824209 824424 828392 ] |
||||||||||||||||||||||||||||||
|
13.28 ms (7.18%) |
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 726449 743955 576392 728995 810591 828392 775051 679361 595478 733911 598150 575485 564461 636270 570265 576330 766563 824209 817495 775595 569681 659274 688403 621733 736345 506474 665258 815766 719108 549292 737386 804783 579596 672743 659721 548660 572508 570525 573286 558573 569913 574978 576276 651909 593915 595690 602638 734345 390071 573290 555788 743086 659113 466394 824424 820453 562104 812088 551952 558469 546730 814578 657697 668865 675813 658713 622626 790242 744796 758525 570207 818936 551619 559501 575122 572134 575053 564420 575702 714452 552798 566925 795585 794524 724750 779915 557228 661540 670817 674778 723487 658556 663365 671115 656965 660562 799608 730649 571390 780485 812143 468209 818433 828101 631299 576109 547649 570061 730570 12897 573598 671325 543750 583641 549329 550564 568051 569906 570919 572378 ] |
||||||||||||||||||||||||||||||
|
3.75 ms (2.03%) |
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 12897 390071 466394 468209 506474 543750 546730 547649 548660 549292 549329 550564 551619 551952 552798 555788 557228 558469 558573 559501 562104 564420 564461 566925 568051 569681 569906 569913 570061 570207 570265 570525 570919 571390 572134 572378 572508 573286 573290 573598 574978 575053 575122 575485 575702 576109 576276 576330 576392 579596 583641 593915 595478 595690 598150 602638 621733 622626 631299 636270 651909 656965 657697 658556 658713 659113 659274 659721 660562 661540 663365 665258 668865 670817 671115 671325 672743 674778 675813 679361 688403 714452 719108 723487 724750 726449 728995 730570 730649 733911 734345 736345 737386 743086 743955 744796 758525 766563 775051 775595 779915 780485 790242 794524 795585 799608 804783 810591 812088 812143 814578 815766 817495 818433 818936 820453 824209 824424 828392 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small pussy hair"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая pussy hair"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая pussy hair"
]
|
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.