Query Metrics
7
Database Queries
7
Different statements
164.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.48 ms (84.06%) |
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 94308 146855 389089 400843 403628 407658 411313 418322 418894 419013 419739 427869 434861 437730 437738 445278 448565 451107 454785 456965 461519 461531 461552 461801 470943 483209 484180 486837 491587 495546 500886 509746 509773 510995 514285 518321 520152 522236 524049 526299 534741 535101 537587 537927 544893 549235 551070 552136 560464 560539 560957 577565 580500 581597 582396 583230 586397 586677 587394 588065 588315 588613 590406 591058 591383 594115 594570 595138 595605 596537 598235 601023 603969 615315 616630 623394 627063 629972 630562 633737 634826 635185 638547 642373 646693 649571 652240 660404 662385 664166 667054 668771 682869 684765 687527 691481 695070 696480 699482 718962 722388 727808 735392 742326 751563 759325 766374 775541 779194 779247 794251 799130 802841 804435 807361 811621 811729 812542 813526 817444 ] |
||||||||||||||||||||||||||||||
|
16.52 ms (10.03%) |
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 560464 577565 583230 649571 660404 696480 682869 615315 633737 586397 594115 595138 603969 590406 595605 598235 811621 799130 766374 742326 807361 437730 400843 419739 461519 461552 389089 418322 461531 500886 514285 518321 524049 484180 491587 146855 407658 418894 437738 434861 817444 451107 520152 534741 526299 537927 560539 560957 582396 544893 549235 552136 699482 718962 662385 684765 695070 652240 664166 687527 580500 581597 588065 588613 629972 635185 586677 588315 627063 630562 634826 779194 812542 779247 794251 802841 727808 751563 735392 759325 642373 722388 804435 403628 419013 456965 461801 470943 427869 454785 411313 509773 483209 486837 495546 522236 509746 813526 94308 445278 448565 510995 537587 535101 667054 668771 646693 691481 551070 594570 596537 591058 601023 616630 638547 587394 591383 623394 775541 811729 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.57%) |
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 94308 146855 389089 400843 403628 407658 411313 418322 418894 419013 419739 427869 434861 437730 437738 445278 448565 451107 454785 456965 461519 461531 461552 461801 470943 483209 484180 486837 491587 495546 500886 509746 509773 510995 514285 518321 520152 522236 524049 526299 534741 535101 537587 537927 544893 549235 551070 552136 560464 560539 560957 577565 580500 581597 582396 583230 586397 586677 587394 588065 588315 588613 590406 591058 591383 594115 594570 595138 595605 596537 598235 601023 603969 615315 616630 623394 627063 629972 630562 633737 634826 635185 638547 642373 646693 649571 652240 660404 662385 664166 667054 668771 682869 684765 687527 691481 695070 696480 699482 718962 722388 727808 735392 742326 751563 759325 766374 775541 779194 779247 794251 799130 802841 804435 807361 811621 811729 812542 813526 817444 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"new girls"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"new девушк"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"new девушк"
]
|
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.