Query Metrics
7
Database Queries
7
Different statements
184.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.12 ms (85.55%) |
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 398900 399152 402507 416607 416691 418127 418149 418259 419646 424795 429278 429547 435171 435553 437874 441041 441050 441071 441106 441952 442548 443914 449956 450437 451157 452572 457797 461309 468037 469794 469826 470883 473410 474806 476713 478986 479008 480279 489318 490692 492275 492717 493083 502877 505803 508154 510230 515452 518962 521094 521108 523866 525720 525744 526069 527194 528429 537640 537757 540915 545001 558949 561979 568916 578380 580770 584226 584812 588538 589390 591446 592917 595612 602136 604055 607180 619189 621546 622509 626378 628948 642390 643005 643380 646923 662144 673987 680928 693761 693804 714079 714091 723643 724498 729567 738464 741310 745900 746235 747444 752759 755198 757512 760583 761150 789042 793187 796336 796650 796675 801236 806931 807578 807948 811507 811808 812495 815430 816057 817875 ] |
||||||||||||||||||||||||||||||
|
15.26 ms (8.25%) |
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 545001 561979 584226 628948 626378 589390 643380 604055 789042 796650 811507 793187 812495 807578 752759 738464 760583 745900 755198 757512 761150 796675 807948 473410 461309 474806 418259 435553 478986 418127 457797 510230 523866 493083 492275 502877 505803 443914 441106 723643 816057 451157 476713 537640 521094 526069 714091 662144 693761 673987 693804 558949 607180 621546 642390 591446 592917 729567 796336 747444 724498 746235 714079 801236 399152 518962 441071 515452 416691 442548 588538 418149 452572 568916 580770 419646 437874 441041 646923 602136 595612 806931 470883 441050 398900 416607 815430 817875 479008 508154 578380 540915 584812 680928 622509 619189 643005 811808 741310 468037 480279 402507 435171 449956 489318 492717 528429 424795 429547 441952 429278 469794 469826 450437 490692 525720 525744 537757 521108 527194 ] |
||||||||||||||||||||||||||||||
|
4.15 ms (2.25%) |
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 398900 399152 402507 416607 416691 418127 418149 418259 419646 424795 429278 429547 435171 435553 437874 441041 441050 441071 441106 441952 442548 443914 449956 450437 451157 452572 457797 461309 468037 469794 469826 470883 473410 474806 476713 478986 479008 480279 489318 490692 492275 492717 493083 502877 505803 508154 510230 515452 518962 521094 521108 523866 525720 525744 526069 527194 528429 537640 537757 540915 545001 558949 561979 568916 578380 580770 584226 584812 588538 589390 591446 592917 595612 602136 604055 607180 619189 621546 622509 626378 628948 642390 643005 643380 646923 662144 673987 680928 693761 693804 714079 714091 723643 724498 729567 738464 741310 745900 746235 747444 752759 755198 757512 760583 761150 789042 793187 796336 796650 796675 801236 806931 807578 807948 811507 811808 812495 815430 816057 817875 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl squirting"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк squirting"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк squirting"
]
|
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.