Query Metrics
7
Database Queries
7
Different statements
192.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.02 ms (86.87%) |
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 6840 7308 86241 88664 149429 187723 193761 233298 312447 382748 385906 387368 390925 393122 393306 393502 395184 395344 397464 402234 411130 411323 420197 425355 427024 428093 429341 432017 433639 437170 440667 441965 442988 444237 446594 448671 449014 452530 457257 460164 465977 466318 466612 466615 467919 469912 472064 472356 475845 475858 478239 480561 491696 492615 499841 507104 515606 526880 528686 530341 535316 543196 544602 546164 547200 548059 548912 549374 550589 551575 551926 551953 552937 555549 555668 557001 557263 557524 560265 560397 560653 563210 563454 563495 564283 564640 567740 569945 570145 570225 572396 573233 577481 580990 589833 591128 591158 591534 595767 597118 597283 598747 600437 622607 625618 653506 654724 656418 657279 657884 658349 658888 668441 677132 687155 687502 690858 712063 794786 825545 ] |
||||||||||||||||||||||||||||||
|
14.24 ms (7.41%) |
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 390925 467919 475858 551926 656418 544602 557001 560397 569945 591128 794786 6840 448671 397464 465977 427024 466615 530341 548059 555549 560653 570145 563495 677132 657884 552937 597283 600437 591534 88664 420197 444237 469912 149429 233298 411323 526880 492615 393502 668441 595767 402234 393306 460164 551953 560265 557263 557524 573233 690858 712063 625618 387368 598747 440667 442988 429341 441965 428093 411130 425355 433639 449014 528686 535316 548912 549374 546164 551575 555668 577481 654724 687155 653506 658349 597118 622607 437170 193761 395184 472356 478239 491696 385906 432017 570225 550589 564283 580990 543196 563454 657279 658888 567740 589833 591158 187723 7308 86241 382748 395344 466318 499841 393122 312447 825545 452530 457257 466612 472064 475845 446594 480561 515606 507104 564640 547200 563210 572396 687502 ] |
||||||||||||||||||||||||||||||
|
4.50 ms (2.34%) |
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 6840 7308 86241 88664 149429 187723 193761 233298 312447 382748 385906 387368 390925 393122 393306 393502 395184 395344 397464 402234 411130 411323 420197 425355 427024 428093 429341 432017 433639 437170 440667 441965 442988 444237 446594 448671 449014 452530 457257 460164 465977 466318 466612 466615 467919 469912 472064 472356 475845 475858 478239 480561 491696 492615 499841 507104 515606 526880 528686 530341 535316 543196 544602 546164 547200 548059 548912 549374 550589 551575 551926 551953 552937 555549 555668 557001 557263 557524 560265 560397 560653 563210 563454 563495 564283 564640 567740 569945 570145 570225 572396 573233 577481 580990 589833 591128 591158 591534 595767 597118 597283 598747 600437 622607 625618 653506 654724 656418 657279 657884 658349 658888 668441 677132 687155 687502 690858 712063 794786 825545 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck skirt"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс юбк"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.76%) |
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.