Query Metrics
7
Database Queries
7
Different statements
186.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.17 ms (84.99%) |
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 42917 149429 233570 305556 325253 334474 382419 382540 382573 383735 384594 386974 387245 387368 387854 389560 390461 392611 393306 398195 398853 398974 401785 402239 403872 405904 412857 413109 416925 426767 428093 429341 432483 432657 442060 443327 446478 453406 454301 457011 458736 459172 460164 461252 465190 465977 466462 467784 475048 484234 485348 490812 491360 492418 492770 512200 513167 522571 528305 528675 529906 529916 529924 532070 535710 536720 539932 547058 547870 549374 550117 550149 551534 551926 551953 553163 553334 554492 554788 556855 557263 557454 557524 560265 562849 563942 569726 572734 573233 574143 576729 581555 588344 594903 600213 609040 613647 617074 621026 622354 622607 625618 634400 642113 647147 647217 657145 657884 658349 659682 660934 665094 690858 707310 712063 782081 782152 817876 825559 825611 ] |
||||||||||||||||||||||||||||||
|
17.06 ms (9.16%) |
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 528305 512200 492418 551953 572734 690858 647217 562849 613647 621026 782081 475048 233570 382573 390461 443327 454301 485348 393306 392611 325253 334474 382419 42917 387854 398195 398853 403872 405904 432657 426767 416925 817876 825559 825611 490812 457011 459172 460164 484234 491360 446478 453406 513167 522571 529924 528675 529916 532070 535710 550149 553334 554492 560265 574143 576729 557263 547058 554788 557524 569726 573233 581555 659682 665094 712063 657145 660934 547870 553163 556855 563942 594903 622354 642113 634400 625618 588344 782152 617074 707310 382540 386974 401785 412857 413109 432483 383735 387245 398974 467784 305556 458736 387368 402239 492770 389560 429341 442060 428093 465190 529906 536720 539932 551534 551926 549374 647147 657884 658349 550117 557454 600213 609040 622607 384594 149429 461252 465977 466462 ] |
||||||||||||||||||||||||||||||
|
3.24 ms (1.74%) |
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 42917 149429 233570 305556 325253 334474 382419 382540 382573 383735 384594 386974 387245 387368 387854 389560 390461 392611 393306 398195 398853 398974 401785 402239 403872 405904 412857 413109 416925 426767 428093 429341 432483 432657 442060 443327 446478 453406 454301 457011 458736 459172 460164 461252 465190 465977 466462 467784 475048 484234 485348 490812 491360 492418 492770 512200 513167 522571 528305 528675 529906 529916 529924 532070 535710 536720 539932 547058 547870 549374 550117 550149 551534 551926 551953 553163 553334 554492 554788 556855 557263 557454 557524 560265 562849 563942 569726 572734 573233 574143 576729 581555 588344 594903 600213 609040 613647 617074 621026 622354 622607 625618 634400 642113 647147 647217 657145 657884 658349 659682 660934 665094 690858 707310 712063 782081 782152 817876 825559 825611 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"без юбк"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"без юбки"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.90%) |
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.