Query Metrics
7
Database Queries
7
Different statements
233.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
202.42 ms (86.66%) |
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 401322 402202 411383 412540 412716 418774 420737 421660 422353 424220 424440 424624 426031 426461 426872 428967 436174 443007 443428 443736 444560 445274 447327 450657 451502 458739 459505 461575 465999 468307 470342 473941 474216 474330 477398 478131 481059 483993 484577 484856 485537 488729 490059 491144 491374 494123 496143 497186 497563 499125 499530 502085 502950 504311 506208 509491 512713 512894 514212 523313 533722 549999 551175 552705 553673 553946 555837 556316 560325 560615 561621 561640 561720 562298 564452 565378 567184 567398 567402 567409 568315 568359 569638 569851 569887 570346 570469 570493 570614 570650 571541 571890 572092 572103 572137 572152 572171 572441 572798 572919 573004 573875 573901 575504 575730 576268 589112 590460 591747 598703 603976 620785 653219 654753 656470 668607 741605 764548 782093 786522 ] |
||||||||||||||||||||||||||||||
|
19.85 ms (8.50%) |
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 572171 573004 668607 562298 572103 572137 764548 620785 786522 436174 474216 443736 459505 504311 653219 422353 741605 443428 411383 424624 484577 553673 509491 512894 502950 549999 569851 570469 573875 551175 556316 571541 572152 573901 656470 561720 567398 569887 572092 572441 589112 603976 591747 782093 424440 473941 412716 444560 412540 426031 426872 451502 502085 491374 568315 590460 424220 470342 499125 654753 494123 560325 561621 572798 575730 567409 598703 402202 421660 474330 418774 443007 458739 447327 468307 477398 461575 465999 478131 484856 496143 497186 506208 483993 488729 499530 512713 491144 497563 514212 523313 426461 420737 401322 450657 445274 428967 485537 490059 533722 481059 552705 553946 555837 560615 561640 564452 565378 567402 568359 569638 570346 570650 571890 572919 567184 570493 570614 575504 576268 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.20%) |
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 401322 402202 411383 412540 412716 418774 420737 421660 422353 424220 424440 424624 426031 426461 426872 428967 436174 443007 443428 443736 444560 445274 447327 450657 451502 458739 459505 461575 465999 468307 470342 473941 474216 474330 477398 478131 481059 483993 484577 484856 485537 488729 490059 491144 491374 494123 496143 497186 497563 499125 499530 502085 502950 504311 506208 509491 512713 512894 514212 523313 533722 549999 551175 552705 553673 553946 555837 556316 560325 560615 561621 561640 561720 562298 564452 565378 567184 567398 567402 567409 568315 568359 569638 569851 569887 570346 570469 570493 570614 570650 571541 571890 572092 572103 572137 572152 572171 572441 572798 572919 573004 573875 573901 575504 575730 576268 589112 590460 591747 598703 603976 620785 653219 654753 656470 668607 741605 764548 782093 786522 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny russian blonde"
]
|
||||||||||||||||||||||||||||||
|
2.47 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые русск беловолосая"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.73%) |
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.