Query Metrics
7
Database Queries
7
Different statements
145.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.61 ms (86.95%) |
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 251363 383911 385316 385483 387301 392825 394409 396154 403928 416695 419953 420481 421002 428381 430333 435865 437854 437925 438857 444650 445533 452675 453528 456380 456511 459685 461802 462338 465202 466985 468321 468919 469031 469045 469592 469817 469847 469848 472327 475422 477864 479713 482929 483483 485294 488322 489822 491381 491490 493339 497887 498888 500565 500679 501267 504660 506117 508760 511648 512563 517616 517854 522263 526197 528684 529708 531075 531701 531782 533305 545526 548623 550236 551183 554213 555636 557625 559660 562209 566527 566624 569913 573655 574646 576115 578461 581691 581938 587079 591544 593669 599028 604794 610813 612854 616515 618461 622472 624982 628558 633147 641095 668790 675866 677516 708348 735511 735647 744251 752790 755743 767086 770228 784664 787774 796950 797023 801545 804862 807048 ] |
||||||||||||||||||||||||||||||
|
10.92 ms (7.50%) |
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 511648 554213 599028 622472 452675 559660 618461 437854 453528 469031 500679 466985 616515 735511 610813 420481 612854 628558 796950 555636 468321 468919 461802 587079 392825 456511 517854 675866 562209 529708 528684 419953 483483 489822 396154 581691 438857 475422 506117 573655 581938 752790 469817 744251 493339 784664 500565 533305 550236 383911 501267 633147 497887 531782 574646 604794 807048 801545 770228 469592 469045 767086 557625 469847 462338 435865 465202 508760 488322 566624 569913 804862 576115 797023 477864 591544 531075 512563 403928 491490 578461 755743 385316 428381 735647 485294 504660 624982 387301 522263 548623 593669 394409 641095 456380 677516 421002 668790 385483 251363 472327 491381 517616 526197 787774 498888 545526 444650 437925 416695 566527 479713 708348 459685 482929 430333 551183 469848 531701 445533 ] |
||||||||||||||||||||||||||||||
|
2.24 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 251363 383911 385316 385483 387301 392825 394409 396154 403928 416695 419953 420481 421002 428381 430333 435865 437854 437925 438857 444650 445533 452675 453528 456380 456511 459685 461802 462338 465202 466985 468321 468919 469031 469045 469592 469817 469847 469848 472327 475422 477864 479713 482929 483483 485294 488322 489822 491381 491490 493339 497887 498888 500565 500679 501267 504660 506117 508760 511648 512563 517616 517854 522263 526197 528684 529708 531075 531701 531782 533305 545526 548623 550236 551183 554213 555636 557625 559660 562209 566527 566624 569913 573655 574646 576115 578461 581691 581938 587079 591544 593669 599028 604794 610813 612854 616515 618461 622472 624982 628558 633147 641095 668790 675866 677516 708348 735511 735647 744251 752790 755743 767086 770228 784664 787774 796950 797023 801545 804862 807048 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"девушки сексом"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк секс"
]
|
||||||||||||||||||||||||||||||
|
1.29 ms (0.89%) |
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.