Query Metrics
7
Database Queries
7
Different statements
143.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.16 ms (82.77%) |
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 2208 325743 382276 383581 384570 385528 387716 387883 388108 388925 393442 393700 396748 397389 401089 401350 401979 402060 402062 403377 407618 409372 409613 412315 414092 416090 417023 425954 426933 428141 428366 429239 429391 429936 435420 439729 446350 447628 452208 456198 458170 458830 459443 461500 462508 463120 464433 466029 467069 467361 468485 469863 470260 470510 471533 472340 472560 472796 473803 474990 475496 478865 484872 488902 490653 490839 491145 491472 491958 491976 492081 496065 496796 497576 501169 501519 510535 510662 510664 511064 511188 515310 525714 526393 526968 533464 544521 545720 548620 549773 550374 557910 559985 560390 561312 561701 565819 570218 570648 571615 571876 571924 573093 573306 573545 573831 573882 575761 597114 610688 663386 663410 663857 663973 667829 681216 716804 724050 729886 804876 ] |
||||||||||||||||||||||||||||||
|
15.32 ms (10.64%) |
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 470260 446350 533464 570218 575761 663973 681216 414092 525714 409372 515310 402060 490839 491958 573306 663410 663857 469863 461500 388925 417023 385528 463120 548620 559985 573093 409613 456198 458170 466029 490653 511188 484872 492081 471533 468485 467069 549773 557910 570648 571924 544521 667829 571876 729886 804876 473803 2208 401350 439729 511064 610688 459443 510664 429391 402062 426933 428366 496796 488902 561701 663386 597114 724050 388108 382276 472796 526393 501169 510535 383581 384570 470510 387883 397389 396748 401979 412315 716804 387716 464433 401089 429936 435420 472340 510662 496065 393442 452208 478865 561312 573545 573831 416090 403377 462508 425954 429239 474990 491472 501519 491145 491976 497576 526968 325743 407618 428141 447628 458830 467361 472560 475496 550374 560390 571615 565819 545720 573882 393700 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.76%) |
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 2208 325743 382276 383581 384570 385528 387716 387883 388108 388925 393442 393700 396748 397389 401089 401350 401979 402060 402062 403377 407618 409372 409613 412315 414092 416090 417023 425954 426933 428141 428366 429239 429391 429936 435420 439729 446350 447628 452208 456198 458170 458830 459443 461500 462508 463120 464433 466029 467069 467361 468485 469863 470260 470510 471533 472340 472560 472796 473803 474990 475496 478865 484872 488902 490653 490839 491145 491472 491958 491976 492081 496065 496796 497576 501169 501519 510535 510662 510664 511064 511188 515310 525714 526393 526968 533464 544521 545720 548620 549773 550374 557910 559985 560390 561312 561701 565819 570218 570648 571615 571876 571924 573093 573306 573545 573831 573882 575761 597114 610688 663386 663410 663857 663973 667829 681216 716804 724050 729886 804876 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"оттрахали худенького …"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс худой"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.11%) |
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.