Query Metrics
7
Database Queries
7
Different statements
168.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.20 ms (81.23%) |
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 4298 410602 416092 427383 428068 428933 432361 433186 444109 451257 455917 456807 457991 462564 463172 463262 465381 469494 469656 470091 471435 473891 474806 476282 476344 477722 477938 477955 478933 479211 480064 480817 480959 481664 482296 482798 484854 484973 486013 488594 488993 489573 489627 490086 492011 492334 494702 495159 498435 498740 502002 502910 504602 508116 510043 511306 511520 516653 517106 517713 520455 520746 522168 522386 523539 525251 526773 527791 530528 543255 544468 546125 550442 552635 554259 560206 561682 563427 563540 563659 564429 565958 566375 566833 567342 568122 569540 569690 569885 569913 570655 571227 571793 573640 574294 575803 576274 576991 577320 580670 581172 582114 585668 589129 592054 595506 595755 595757 597830 601407 603102 605855 608497 620203 621397 624838 627700 628351 636322 679097 ] |
||||||||||||||||||||||||||||||
|
20.35 ms (12.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 498740 526773 546125 476282 492011 581172 463172 477955 465381 522168 480064 563540 636322 620203 550442 627700 563659 4298 416092 456807 477938 479211 488594 569913 595506 474806 455917 502002 525251 527791 478933 469494 570655 482798 511306 522386 575803 574294 554259 624838 410602 566833 427383 504602 564429 484854 490086 569885 595755 432361 567342 565958 595757 597830 480959 462564 520455 492334 433186 457991 482296 484973 517713 543255 544468 568122 569540 569690 571793 552635 560206 576274 576991 577320 608497 589129 628351 477722 476344 508116 489627 517106 489573 498435 523539 494702 451257 603102 428933 481664 480817 473891 502910 516653 510043 530528 471435 580670 582114 561682 679097 563427 571227 605855 463262 470091 469656 511520 621397 585668 566375 520746 573640 444109 428068 495159 486013 488993 592054 601407 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.78%) |
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 4298 410602 416092 427383 428068 428933 432361 433186 444109 451257 455917 456807 457991 462564 463172 463262 465381 469494 469656 470091 471435 473891 474806 476282 476344 477722 477938 477955 478933 479211 480064 480817 480959 481664 482296 482798 484854 484973 486013 488594 488993 489573 489627 490086 492011 492334 494702 495159 498435 498740 502002 502910 504602 508116 510043 511306 511520 516653 517106 517713 520455 520746 522168 522386 523539 525251 526773 527791 530528 543255 544468 546125 550442 552635 554259 560206 561682 563427 563540 563659 564429 565958 566375 566833 567342 568122 569540 569690 569885 569913 570655 571227 571793 573640 574294 575803 576274 576991 577320 580670 581172 582114 585668 589129 592054 595506 595755 595757 597830 601407 603102 605855 608497 620203 621397 624838 627700 628351 636322 679097 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"куни со спины"
]
|
||||||||||||||||||||||||||||||
|
2.12 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куннилингус оральн секс спин"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"куннилингус оральн секс спин"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.99%) |
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.