Query Metrics
7
Database Queries
7
Different statements
176.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.26 ms (84.63%) |
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 7051 125762 391310 396640 397263 397296 397852 421590 441485 442136 443884 467948 478078 483559 487363 501035 525591 529131 531647 533333 539276 539559 547417 548254 549020 549075 559996 560289 560939 564223 564555 572181 575846 578207 590807 591082 592399 604287 612363 616743 625771 628484 631525 633323 634511 637224 646002 651873 654346 654918 680251 697545 698012 699899 702636 706572 710736 712141 714081 717213 720080 720192 722583 729079 730415 734326 734964 735776 742742 743083 745069 747498 750129 751496 756160 757535 760888 761679 767090 769038 769070 769851 771318 771923 775532 776040 776960 777029 777207 778951 778992 779010 779241 779730 779741 781331 781355 782544 782619 783075 783178 783180 787887 788786 789871 790637 791215 791246 791594 792183 795523 795710 795836 796916 797063 800523 800554 809757 810329 ] |
||||||||||||||||||||||||||||||
|
16.36 ms (9.27%) |
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 637224 779241 779730 790637 760888 782544 783180 743083 761679 771923 729079 771318 712141 776040 777029 783075 788786 559996 791215 769851 591082 539559 483559 560939 628484 717213 634511 795710 751496 810329 397852 631525 578207 501035 564223 625771 654918 796916 791246 734964 734326 742742 757535 397263 533333 769740 391310 698012 443884 800554 397296 777207 750129 809757 125762 779741 783178 797063 646002 612363 421590 720080 548254 539276 699899 654346 604287 747498 767090 702636 787887 789871 467948 531647 775532 7051 547417 549020 714081 706572 781355 795523 735776 745069 633323 487363 396640 525591 529131 564555 791594 778951 756160 769038 781331 441485 575846 572181 590807 592399 730415 478078 651873 722583 779010 795836 800523 769070 792183 710736 776960 778992 560289 680251 442136 549075 720192 616743 782619 697545 ] |
||||||||||||||||||||||||||||||
|
3.70 ms (2.10%) |
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 7051 125762 391310 396640 397263 397296 397852 421590 441485 442136 443884 467948 478078 483559 487363 501035 525591 529131 531647 533333 539276 539559 547417 548254 549020 549075 559996 560289 560939 564223 564555 572181 575846 578207 590807 591082 592399 604287 612363 616743 625771 628484 631525 633323 634511 637224 646002 651873 654346 654918 680251 697545 698012 699899 702636 706572 710736 712141 714081 717213 720080 720192 722583 729079 730415 734326 734964 735776 742742 743083 745069 747498 750129 751496 756160 757535 760888 761679 767090 769038 769070 769851 771318 771923 775532 776040 776960 777029 777207 778951 778992 779010 779241 779730 779741 781331 781355 782544 782619 783075 783178 783180 787887 788786 789871 790637 791215 791246 791594 792183 795523 795710 795836 796916 797063 800523 800554 809757 810329 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"кончил девушку в попу%…"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм девушк анал"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.87%) |
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.