Query Metrics
7
Database Queries
7
Different statements
158.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.14 ms (84.78%) |
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 7390 431963 437294 438708 438879 442390 443029 447709 448434 457069 459655 461634 462659 463151 467620 470269 470827 484022 484075 484252 487153 488196 489792 489798 492775 495302 503485 505189 505423 506118 506517 507871 510567 510699 510721 515651 517117 517602 519126 519768 520299 523430 527250 527578 528899 530776 536154 541101 542054 544042 544104 546419 548034 552140 552326 553238 554414 554625 554748 560099 566911 571656 572211 572214 576742 577509 579661 580105 583954 584245 585684 588338 592093 593758 593769 598124 598965 599040 599045 601377 601988 603704 606297 608581 609568 612092 617122 617373 618199 626143 626268 630472 633832 634432 635621 635627 650528 651431 654273 656744 658353 659714 660963 663948 665415 709650 725339 733239 747059 749633 760439 764190 765512 768186 768590 771508 774343 793185 807847 ] |
||||||||||||||||||||||||||||||
|
14.97 ms (9.46%) |
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 633832 626268 807847 747059 510699 470827 459655 576742 527250 577509 598124 585684 725339 470269 749633 764190 774343 553238 580105 601377 608581 635621 612092 506517 503485 542054 560099 658353 663948 554748 593758 588338 617373 760439 733239 527578 463151 630472 484252 519768 507871 579661 793185 765512 768186 771508 768590 554625 489798 519126 510567 664464 438708 457069 505189 510721 488196 489792 7390 492775 544042 583954 544104 650528 654273 651431 598965 467620 487153 505423 634432 552326 665415 566911 617122 592093 447709 462659 599045 618199 606297 626143 506118 584245 484075 552140 443029 438879 431963 515651 484022 442390 541101 437294 448434 656744 546419 548034 572211 660963 572214 593769 599040 635627 554414 709650 609568 601988 659714 517117 520299 536154 571656 517602 461634 523430 528899 495302 530776 603704 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.54%) |
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 7390 431963 437294 438708 438879 442390 443029 447709 448434 457069 459655 461634 462659 463151 467620 470269 470827 484022 484075 484252 487153 488196 489792 489798 492775 495302 503485 505189 505423 506118 506517 507871 510567 510699 510721 515651 517117 517602 519126 519768 520299 523430 527250 527578 528899 530776 536154 541101 542054 544042 544104 546419 548034 552140 552326 553238 554414 554625 554748 560099 566911 571656 572211 572214 576742 577509 579661 580105 583954 584245 585684 588338 592093 593758 593769 598124 598965 599040 599045 601377 601988 603704 606297 608581 609568 612092 617122 617373 618199 626143 626268 630472 633832 634432 635621 635627 650528 651431 654273 656744 658353 659714 660963 663948 665415 709650 725339 733239 747059 749633 760439 764190 765512 768186 768590 771508 774343 793185 807847 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"handjob stranger"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк член stranger"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дрочк член stranger"
]
|
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.