Query Metrics
7
Database Queries
7
Different statements
159.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.11 ms (84.68%) |
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 4266 8925 20180 28625 91928 113322 114313 149406 182285 193761 212963 213113 213573 213819 233269 233647 265933 270290 305201 362746 365993 381995 382298 382746 382816 384296 384392 385880 386449 387279 387433 387786 388761 390195 390734 394420 396438 397765 397846 402941 406371 419029 420308 431716 432390 432408 432537 432573 433395 433814 434842 437782 439571 444717 456664 461255 468058 469753 479703 482078 484636 496420 502813 505584 507540 511097 515622 518739 518806 520924 524364 527637 530436 533459 539926 542685 546370 556574 556804 558341 560276 565539 584101 588373 595300 597003 598871 608288 609540 617074 626576 641531 661966 663716 672877 677357 700831 705140 740119 740567 743508 747799 757083 759602 759702 764168 767986 769017 769124 771392 773825 778227 780416 780857 782130 788425 796551 797029 797030 812506 ] |
||||||||||||||||||||||||||||||
|
14.20 ms (8.90%) |
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 524364 677357 434842 511097 584101 469753 20180 461255 556574 597003 502813 444717 598871 542685 609540 626576 507540 406371 390734 484636 565539 518739 546370 505584 527637 365993 743508 114313 212963 759702 8925 769124 780416 456664 533459 382298 740567 382816 397765 149406 362746 381995 419029 812506 468058 396438 390195 556804 661966 780857 764168 28625 233269 265933 740119 386449 213113 432390 420308 515622 431716 518806 113322 617074 705140 233647 4266 387786 757083 782130 747799 397846 182285 608288 382746 213819 767986 385880 432537 433814 663716 672877 778227 797029 193761 432408 797030 759602 387279 479703 305201 558341 387433 384296 384392 402941 641531 588373 773825 437782 482078 439571 432573 520924 560276 595300 788425 771392 769017 496420 539926 388761 91928 433395 700831 796551 530436 394420 213573 270290 ] |
||||||||||||||||||||||||||||||
|
3.87 ms (2.43%) |
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 4266 8925 20180 28625 91928 113322 114313 149406 182285 193761 212963 213113 213573 213819 233269 233647 265933 270290 305201 362746 365993 381995 382298 382746 382816 384296 384392 385880 386449 387279 387433 387786 388761 390195 390734 394420 396438 397765 397846 402941 406371 419029 420308 431716 432390 432408 432537 432573 433395 433814 434842 437782 439571 444717 456664 461255 468058 469753 479703 482078 484636 496420 502813 505584 507540 511097 515622 518739 518806 520924 524364 527637 530436 533459 539926 542685 546370 556574 556804 558341 560276 565539 584101 588373 595300 597003 598871 608288 609540 617074 626576 641531 661966 663716 672877 677357 700831 705140 740119 740567 743508 747799 757083 759602 759702 764168 767986 769017 769124 771392 773825 778227 780416 780857 782130 788425 796551 797029 797030 812506 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tights fuck"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"колготк секс"
]
|
||||||||||||||||||||||||||||||
|
1.19 ms (0.75%) |
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.