Query Metrics
7
Database Queries
7
Different statements
156.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.02 ms (77.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 282010 381752 395503 396590 404340 405921 406322 406381 411581 416098 419370 420925 421995 425164 425490 428353 429088 432662 434000 434001 436032 448445 448839 450822 450836 452018 452228 452282 459830 463842 469534 473831 473920 474539 477686 478672 480429 481147 482527 484673 485541 491270 494345 497356 499852 499882 507666 507680 508156 512891 517651 517743 517784 518438 521367 524183 524213 524879 527273 527412 527447 528586 530017 530060 530061 530369 530377 530637 530912 531123 532645 532666 532680 532755 534842 536590 536752 537659 537660 545614 551137 551222 553269 568328 583003 584720 587192 597216 599726 599988 600030 604524 605532 614056 623205 629961 632563 633166 639732 643113 645993 646448 646849 649556 724271 815697 ] |
||||||||||||||||||||||||||||||
|
23.52 ms (15.00%) |
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 429088 815697 432662 421995 545614 568328 452228 521367 527412 452282 396590 491270 434000 416098 473831 517784 623205 524213 406322 604524 643113 724271 395503 473920 434001 405921 528586 645993 425164 480429 508156 536752 537659 583003 649556 599726 633166 499882 551137 527273 507666 629961 450822 404340 534842 420925 381752 282010 448445 536590 551222 436032 512891 481147 646849 494345 452018 537660 530060 524183 530017 614056 485541 605532 450836 600030 459830 587192 497356 428353 532645 477686 553269 474539 530912 530061 507680 530377 425490 419370 524879 531123 484673 482527 448839 406381 527447 532680 639732 518438 517651 411581 463842 530637 646448 469534 532755 597216 517743 478672 530369 599988 532666 584720 632563 499852 ] |
||||||||||||||||||||||||||||||
|
4.00 ms (2.55%) |
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 282010 381752 395503 396590 404340 405921 406322 406381 411581 416098 419370 420925 421995 425164 425490 428353 429088 432662 434000 434001 436032 448445 448839 450822 450836 452018 452228 452282 459830 463842 469534 473831 473920 474539 477686 478672 480429 481147 482527 484673 485541 491270 494345 497356 499852 499882 507666 507680 508156 512891 517651 517743 517784 518438 521367 524183 524213 524879 527273 527412 527447 528586 530017 530060 530061 530369 530377 530637 530912 531123 532645 532666 532680 532755 534842 536590 536752 537659 537660 545614 551137 551222 553269 568328 583003 584720 587192 597216 599726 599988 600030 604524 605532 614056 623205 629961 632563 633166 639732 643113 645993 646448 646849 649556 724271 815697 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young bbc sex"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young bbc секс"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young bbc секс"
]
|
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.