Query Metrics
7
Database Queries
7
Different statements
147.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.09 ms (84.04%) |
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 66348 172514 381742 386872 400497 420230 434089 443932 459933 460132 465771 481515 485740 488224 494642 497441 500007 500576 503985 511787 517077 517282 519653 520698 532138 533910 543306 543822 545924 546272 546460 549534 549717 551110 557224 557327 558341 561886 563016 566880 567415 572355 576709 579811 584639 590975 590977 591030 591059 591452 591470 591735 593821 596980 599720 609604 617263 624993 627648 636249 642348 642394 646610 678628 685516 691793 696958 700513 701907 704391 705321 705391 705411 714015 717688 717914 719157 724032 724090 729912 730924 734180 744735 747797 747801 750034 753815 760107 764624 765820 771407 771999 777178 778191 778667 779451 779459 779651 781843 782423 783742 783816 786180 789592 789604 789649 790400 792032 793236 795443 795590 795980 796481 797751 801436 801623 805108 806754 813274 813314 ] |
||||||||||||||||||||||||||||||
|
13.36 ms (9.05%) |
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 795590 386872 627648 485740 546460 779459 678628 781843 511787 566880 591452 533910 591735 609604 517282 519653 532138 576709 724032 517077 617263 567415 700513 551110 520698 717688 793236 777178 778667 465771 599720 443932 500007 172514 381742 696958 714015 705321 789604 771999 760107 813314 765820 795443 400497 795980 590977 734180 572355 779651 420230 543822 705411 646610 691793 591470 624993 778191 801436 724090 729912 786180 717914 747797 719157 783742 797751 806754 579811 796481 753815 789649 543306 557327 549534 549717 705391 805108 704391 494642 500576 503985 584639 563016 590975 591059 685516 591030 779451 792032 771407 701907 66348 642348 801623 460132 488224 434089 790400 744735 558341 813274 481515 546272 545924 557224 593821 596980 642394 789592 782423 747801 764624 730924 750034 497441 459933 561886 636249 783816 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (2.17%) |
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 66348 172514 381742 386872 400497 420230 434089 443932 459933 460132 465771 481515 485740 488224 494642 497441 500007 500576 503985 511787 517077 517282 519653 520698 532138 533910 543306 543822 545924 546272 546460 549534 549717 551110 557224 557327 558341 561886 563016 566880 567415 572355 576709 579811 584639 590975 590977 591030 591059 591452 591470 591735 593821 596980 599720 609604 617263 624993 627648 636249 642348 642394 646610 678628 685516 691793 696958 700513 701907 704391 705321 705391 705411 714015 717688 717914 719157 724032 724090 729912 730924 734180 744735 747797 747801 750034 753815 760107 764624 765820 771407 771999 777178 778191 778667 779451 779459 779651 781843 782423 783742 783816 786180 789592 789604 789649 790400 792032 793236 795443 795590 795980 796481 797751 801436 801623 805108 806754 813274 813314 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"kitchen blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кухн минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"кухн минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.