Query Metrics
7
Database Queries
7
Different statements
167.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.35 ms (86.31%) |
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 263917 381742 386991 389912 390728 400497 401532 420230 434089 443932 448195 459933 460132 465771 471994 481515 481662 488224 494642 496727 497441 500007 500576 503985 514685 519394 527131 543306 543822 545924 546272 549534 549717 557224 557327 558341 561886 563016 564398 566883 567405 567884 572355 579811 584639 590975 590977 591030 591059 591470 593821 596980 599720 609197 612537 613238 624993 636249 642348 642394 642412 646610 667215 667295 685516 691793 696958 701907 704391 705321 705391 705411 714015 717914 719157 724090 729912 730924 734180 740981 747797 747801 750034 753815 760107 761949 764624 765305 765820 770061 771407 771999 777178 778191 778667 779451 779651 782423 783742 783816 786180 789592 789604 789649 792032 793236 793812 795443 795980 796481 797751 801436 801623 802835 805108 806754 813314 813781 ] |
||||||||||||||||||||||||||||||
|
12.50 ms (7.48%) |
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 793236 777178 778667 465771 599720 443932 500007 566883 172514 381742 496727 696958 714015 667295 705321 642412 789604 771999 760107 765305 770061 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 558341 263917 481515 481662 546272 545924 667215 557224 593821 596980 642394 789592 782423 747801 764624 730924 750034 386991 497441 459933 561886 636249 813781 783816 793812 740981 401532 612537 761949 519394 471994 514685 802835 390728 389912 567884 567405 609197 527131 448195 564398 613238 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.63%) |
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 263917 381742 386991 389912 390728 400497 401532 420230 434089 443932 448195 459933 460132 465771 471994 481515 481662 488224 494642 496727 497441 500007 500576 503985 514685 519394 527131 543306 543822 545924 546272 549534 549717 557224 557327 558341 561886 563016 564398 566883 567405 567884 572355 579811 584639 590975 590977 591030 591059 591470 593821 596980 599720 609197 612537 613238 624993 636249 642348 642394 642412 646610 667215 667295 685516 691793 696958 701907 704391 705321 705391 705411 714015 717914 719157 724090 729912 730924 734180 740981 747797 747801 750034 753815 760107 761949 764624 765305 765820 770061 771407 771999 777178 778191 778667 779451 779651 782423 783742 783816 786180 789592 789604 789649 792032 793236 793812 795443 795980 796481 797751 801436 801623 802835 805108 806754 813314 813781 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob kitchen"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс кухн"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.03%) |
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.