Query Metrics
7
Database Queries
7
Different statements
189.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.89 ms (87.18%) |
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 180923 383358 389740 446352 447974 450148 452946 458782 465903 468285 469365 469873 478816 480273 489620 490806 493023 495736 496343 496781 504060 506878 507032 507128 507204 509829 515083 521736 522158 524260 524494 524634 525829 526480 526893 528762 528874 528995 529372 531016 531297 531701 534724 535145 535490 536871 537783 539429 539619 540973 542153 543530 544276 544310 544342 544832 545881 547207 547358 549816 549961 550154 552212 553278 554058 554156 554453 554525 555146 556337 557497 558785 559806 561761 562290 563934 564490 566335 566643 566728 571817 574438 577570 579255 586636 591222 592472 593087 595684 597118 598867 601513 603213 604182 604422 607255 610024 611304 615048 615202 616587 616996 617353 619845 622029 629370 630428 632288 632859 634848 635266 636139 636230 644512 644688 644885 732422 775540 775593 812537 ] |
||||||||||||||||||||||||||||||
|
14.17 ms (7.49%) |
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 592472 595684 610024 611304 615202 617353 644688 604422 622029 632859 586636 593087 598867 601513 607255 616587 634848 635266 591222 597118 603213 604182 619845 630428 636230 775593 732422 615048 629370 632288 636139 644512 775540 812537 180923 446352 447974 458782 389740 452946 480273 468285 526480 616996 383358 644885 469365 478816 490806 493023 469873 450148 489620 507128 524634 525829 535490 495736 496343 504060 507204 522158 524260 528762 528874 528995 529372 531016 506878 507032 524494 535145 536871 537783 539619 496781 509829 515083 521736 526893 531297 531701 534724 539429 465903 544832 545881 547207 547358 549816 549961 553278 554058 559806 563934 564490 566643 571817 574438 543530 544310 550154 562290 577570 579255 540973 542153 544276 544342 552212 554156 554453 554525 555146 556337 557497 558785 561761 566335 566728 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.48%) |
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 180923 383358 389740 446352 447974 450148 452946 458782 465903 468285 469365 469873 478816 480273 489620 490806 493023 495736 496343 496781 504060 506878 507032 507128 507204 509829 515083 521736 522158 524260 524494 524634 525829 526480 526893 528762 528874 528995 529372 531016 531297 531701 534724 535145 535490 536871 537783 539429 539619 540973 542153 543530 544276 544310 544342 544832 545881 547207 547358 549816 549961 550154 552212 553278 554058 554156 554453 554525 555146 556337 557497 558785 559806 561761 562290 563934 564490 566335 566643 566728 571817 574438 577570 579255 586636 591222 592472 593087 595684 597118 598867 601513 603213 604182 604422 607255 610024 611304 615048 615202 616587 616996 617353 619845 622029 629370 630428 632288 632859 634848 635266 636139 636230 644512 644688 644885 732422 775540 775593 812537 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ше"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"шеи"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.75%) |
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.