Query Metrics
7
Database Queries
7
Different statements
375.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
335.31 ms (89.20%) |
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 393241 400167 409862 412474 417958 420615 425313 431592 435104 440717 444406 445617 446239 449190 453729 453903 455393 456173 456829 457351 457881 458326 459004 459558 459747 461631 463008 463659 463963 463987 464601 464961 465006 465301 466851 468850 469453 470283 471512 471956 472028 472597 472643 473364 473434 473710 475129 475483 475840 475943 476212 478236 479457 481195 481267 481788 482525 483248 483966 484931 485561 487581 488549 489181 489197 489529 489705 489784 490138 490183 490195 491955 492206 492975 495182 495474 496528 497199 497211 497268 499036 499160 502278 502420 502764 503106 503361 504799 505364 505834 506100 506316 506354 508069 509037 509079 510528 512158 512880 513141 513936 513994 514152 515816 519297 519433 520718 521291 524542 524585 524925 525499 526250 526801 527533 527589 527719 529451 536861 561307 ] |
||||||||||||||||||||||||||||||
|
28.86 ms (7.68%) |
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 461631 464601 472643 475840 527533 526250 490183 417958 440717 446239 453903 473710 393241 400167 425313 431592 457351 463987 478236 455393 458326 463008 468850 409862 457881 459747 463659 473364 481195 481267 476212 508069 509079 524925 527589 487581 489181 492975 495182 497199 505364 506316 506354 484931 495474 502764 512880 521291 526801 489784 490195 492206 499036 505834 519433 527719 529451 513141 470283 475483 469453 491955 482525 525499 524542 444406 435104 463963 471956 473434 479457 489705 449190 465301 481788 483966 453729 465006 502278 496528 464961 456173 456829 459004 475129 420615 459558 466851 471512 472028 412474 475943 503361 514152 520718 536861 485561 489197 497268 502420 513936 519297 483248 489529 503106 504799 506100 512158 488549 490138 497211 499160 509037 510528 513994 515816 524585 561307 445617 472597 ] |
||||||||||||||||||||||||||||||
|
4.01 ms (1.07%) |
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 393241 400167 409862 412474 417958 420615 425313 431592 435104 440717 444406 445617 446239 449190 453729 453903 455393 456173 456829 457351 457881 458326 459004 459558 459747 461631 463008 463659 463963 463987 464601 464961 465006 465301 466851 468850 469453 470283 471512 471956 472028 472597 472643 473364 473434 473710 475129 475483 475840 475943 476212 478236 479457 481195 481267 481788 482525 483248 483966 484931 485561 487581 488549 489181 489197 489529 489705 489784 490138 490183 490195 491955 492206 492975 495182 495474 496528 497199 497211 497268 499036 499160 502278 502420 502764 503106 503361 504799 505364 505834 506100 506316 506354 508069 509037 509079 510528 512158 512880 513141 513936 513994 514152 515816 519297 519433 520718 521291 524542 524585 524925 525499 526250 526801 527533 527589 527719 529451 536861 561307 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bra white"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.51%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бюстгалтер нижн бел white"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бюстгалтер нижн бел white"
]
|
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.