Query Metrics
7
Database Queries
7
Different statements
187.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.94 ms (85.63%) |
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 319841 379578 383224 384811 385538 389442 390082 390702 391968 395729 399415 402564 407586 411116 411336 411675 411910 417018 420249 421343 425195 426006 428410 433823 445846 446783 450821 450844 451797 452130 452240 457102 462567 464278 464544 466918 467880 468484 472216 477683 478063 485955 487608 490881 494222 500689 500692 502062 502108 534209 536496 541373 542876 549230 549240 549292 555436 577057 577553 583464 591288 592424 592945 593431 604581 615813 621682 622695 632450 665187 666131 684336 686088 697229 697272 697282 713045 719108 720050 720264 723527 723966 725613 726848 730559 730793 732181 733223 733266 740806 744994 745707 748478 757526 761525 767560 770325 773754 781971 795159 801243 810655 810861 814178 814374 814387 815226 815766 816068 816562 817134 818462 820346 820658 821064 821598 823754 826642 827206 827648 ] |
||||||||||||||||||||||||||||||
|
16.17 ms (8.60%) |
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 815766 823754 817134 536496 534209 555436 684336 686088 666131 697272 697282 719108 549292 577057 622695 592424 615813 801243 726848 745707 795159 810861 730793 733223 723966 730559 757526 761525 767560 732181 740806 770325 773754 632450 781971 810655 391968 411116 379578 385538 390702 390082 411910 407586 814374 452130 468484 451797 462567 466918 502062 500692 549230 577553 549240 713045 665187 697229 720050 720264 591288 604581 593431 592945 733266 748478 725613 744994 411336 457102 421343 541373 383224 417018 826642 827648 445846 452240 464278 450821 542876 583464 621682 395729 402564 425195 446783 500689 490881 485955 384811 319841 389442 399415 420249 426006 411675 433823 428410 814178 814387 821064 821598 723527 820658 827206 816562 820346 815226 816068 818462 450844 467880 464544 472216 477683 478063 487608 494222 502108 ] |
||||||||||||||||||||||||||||||
|
2.86 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 319841 379578 383224 384811 385538 389442 390082 390702 391968 395729 399415 402564 407586 411116 411336 411675 411910 417018 420249 421343 425195 426006 428410 433823 445846 446783 450821 450844 451797 452130 452240 457102 462567 464278 464544 466918 467880 468484 472216 477683 478063 485955 487608 490881 494222 500689 500692 502062 502108 534209 536496 541373 542876 549230 549240 549292 555436 577057 577553 583464 591288 592424 592945 593431 604581 615813 621682 622695 632450 665187 666131 684336 686088 697229 697272 697282 713045 719108 720050 720264 723527 723966 725613 726848 730559 730793 732181 733223 733266 740806 744994 745707 748478 757526 761525 767560 770325 773754 781971 795159 801243 810655 810861 814178 814374 814387 815226 815766 816068 816562 817134 818462 820346 820658 821064 821598 823754 826642 827206 827648 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза волосатая"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"licking hairy"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.92%) |
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.