Query Metrics
7
Database Queries
7
Different statements
285.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
246.68 ms (86.37%) |
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 24243 395985 399473 417338 422187 425654 427498 443262 443744 444594 448172 450077 451089 454317 455435 455471 456482 457643 459954 461394 461788 462930 464481 466019 469947 470953 471648 472409 472674 473572 473575 477463 478753 482909 482917 482933 483320 485002 485429 485441 487022 487067 489901 492521 493191 493311 493997 496357 497064 499230 499587 499695 500825 501912 501938 504347 504351 504352 506441 510157 510930 515786 515868 516325 517091 517599 521076 521168 526967 527038 527756 527968 531903 533499 541470 545539 551627 553147 554234 555509 557226 561079 566322 569427 569561 570086 572841 577400 580666 581118 586390 586493 590127 592417 594566 600565 600586 603095 605698 612961 618166 619816 624661 625103 625127 625140 632715 636643 651731 656660 679281 690726 694608 726289 759135 768581 769504 801912 805624 824683 ] |
||||||||||||||||||||||||||||||
|
28.70 ms (10.05%) |
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 444594 466019 450077 451089 455435 469947 472409 443262 448172 478753 425654 482909 485441 497064 499230 501912 504351 506441 492521 482933 485429 487022 496357 504352 694608 612961 805624 427498 443744 473575 457643 459954 489901 521168 499587 510930 531903 517091 526967 471648 581118 551627 554234 566322 570086 572841 553147 569561 600565 600586 619816 624661 590127 586390 625127 586493 594566 759135 768581 636643 455471 461394 461788 464481 399473 422187 517599 521076 493191 501938 533499 482917 493997 499695 504347 527968 515786 824683 801912 24243 395985 679281 618166 726289 456482 473572 527756 516325 477463 493311 545539 569427 580666 561079 592417 603095 605698 632715 625103 769504 470953 487067 515868 500825 541470 651731 656660 690726 472674 483320 454317 510157 462930 555509 577400 557226 625140 417338 485002 527038 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.08%) |
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 24243 395985 399473 417338 422187 425654 427498 443262 443744 444594 448172 450077 451089 454317 455435 455471 456482 457643 459954 461394 461788 462930 464481 466019 469947 470953 471648 472409 472674 473572 473575 477463 478753 482909 482917 482933 483320 485002 485429 485441 487022 487067 489901 492521 493191 493311 493997 496357 497064 499230 499587 499695 500825 501912 501938 504347 504351 504352 506441 510157 510930 515786 515868 516325 517091 517599 521076 521168 526967 527038 527756 527968 531903 533499 541470 545539 551627 553147 554234 555509 557226 561079 566322 569427 569561 570086 572841 577400 580666 581118 586390 586493 590127 592417 594566 600565 600586 603095 605698 612961 618166 619816 624661 625103 625127 625140 632715 636643 651731 656660 679281 690726 694608 726289 759135 768581 769504 801912 805624 824683 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.69%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скрыт туалет"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hidden toilet"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.58%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.57%) |
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.