Query Metrics
7
Database Queries
7
Different statements
198.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.56 ms (86.82%) |
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 399170 419669 422075 422493 423782 425054 425157 426308 426944 430336 436132 442625 443688 445310 446455 446642 446662 446727 446937 448426 448912 449311 451070 451557 451559 452329 456359 457319 457597 457834 458172 459097 462287 463226 463240 463384 464470 466367 466599 467285 467743 470244 471307 475350 475943 475975 475997 476369 476460 476634 476782 477884 478914 480717 480868 482221 483903 486740 489315 493434 494371 495478 496182 498672 500018 500034 500058 501030 502172 504321 504599 505627 505973 507656 508116 508781 509891 509944 510371 510832 511217 511605 511756 511914 513950 514045 514062 514377 514387 515371 516930 518363 518411 518871 519876 520129 520306 521434 521520 521917 521999 522453 523686 523743 523996 524007 524801 525261 525314 526282 527744 527904 529522 537310 539559 542036 552467 552865 581500 588077 ] |
||||||||||||||||||||||||||||||
|
16.41 ms (8.26%) |
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 511914 514062 489315 483903 539559 542036 552865 581500 446727 462287 467285 475350 423782 457834 470244 476369 480868 463240 464470 457597 478914 425054 442625 456359 463226 475997 500018 509944 514387 521999 523686 524801 529522 498672 504321 508781 511217 511605 511756 513950 494371 502172 504599 518411 521917 523743 525314 526282 493434 495478 505973 527744 527904 520306 519876 552467 466599 471307 448426 515371 523996 476634 419669 436132 446642 466367 475975 457319 458172 467743 422493 430336 449311 482221 446455 452329 505627 520129 521520 496182 500058 510371 486740 501030 518363 525261 500034 510832 514045 516930 463384 518871 537310 588077 426944 446662 476460 477884 448912 459097 476782 399170 426308 445310 446937 422075 425157 443688 451557 480717 451070 451559 475943 507656 508116 509891 514377 521434 522453 524007 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.11%) |
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 399170 419669 422075 422493 423782 425054 425157 426308 426944 430336 436132 442625 443688 445310 446455 446642 446662 446727 446937 448426 448912 449311 451070 451557 451559 452329 456359 457319 457597 457834 458172 459097 462287 463226 463240 463384 464470 466367 466599 467285 467743 470244 471307 475350 475943 475975 475997 476369 476460 476634 476782 477884 478914 480717 480868 482221 483903 486740 489315 493434 494371 495478 496182 498672 500018 500034 500058 501030 502172 504321 504599 505627 505973 507656 508116 508781 509891 509944 510371 510832 511217 511605 511756 511914 513950 514045 514062 514377 514387 515371 516930 518363 518411 518871 519876 520129 520306 521434 521520 521917 521999 522453 523686 523743 523996 524007 524801 525261 525314 526282 527744 527904 529522 537310 539559 542036 552467 552865 581500 588077 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"white leggings russian"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"white лосин русск"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"white лосин русск"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.79%) |
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.