Query Metrics
7
Database Queries
7
Different statements
362.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
334.47 ms (92.22%) |
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 58516 91578 220769 263788 330764 365381 381822 382381 388124 398515 409134 417758 425638 428382 428784 435060 443655 444412 451602 453680 453916 457150 457169 461221 465177 465745 466425 466664 466675 467133 469159 471593 476387 476744 477582 480066 483231 486425 486485 487095 487144 488212 488286 488565 490119 490462 491379 491641 491719 491721 496800 497661 499968 501306 504597 505236 505986 508828 508836 509765 510617 511704 512665 513290 513292 513302 513541 516379 518263 518397 521912 521928 522535 523510 524178 525640 527503 527511 527549 527620 533157 540482 544683 546015 551640 565361 565372 565414 565551 565561 566810 570030 570620 570639 570644 570661 571884 572499 572520 575117 575499 578059 578068 605318 611820 611900 638647 669609 669643 671409 672402 691607 723878 725563 729441 741175 748200 753907 769139 820677 ] |
||||||||||||||||||||||||||||||
|
18.07 ms (4.98%) |
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 382381 466675 417758 453680 466425 435060 465177 504597 516379 527503 487095 490119 491379 491721 509765 511704 513292 483231 486425 508828 513302 525640 501306 523510 611820 443655 444412 486485 476744 499968 513541 466664 469159 565361 570030 575499 578068 565551 571884 551640 570620 578059 565372 565414 565561 570644 575117 451602 457169 480066 428784 457150 471593 476387 425638 428382 512665 513290 527620 488286 491641 491719 505986 518397 521928 518263 521912 524178 540482 488212 505236 508836 510617 527549 611900 570661 546015 572520 453916 465745 490462 487144 605318 58516 533157 729441 522535 91578 398515 409134 820677 488565 669609 723878 725563 753907 769139 741175 748200 381822 263788 527511 544683 467133 497661 477582 570639 671409 672402 691607 638647 388124 365381 572499 669643 496800 461221 566810 220769 330764 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (0.73%) |
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 58516 91578 220769 263788 330764 365381 381822 382381 388124 398515 409134 417758 425638 428382 428784 435060 443655 444412 451602 453680 453916 457150 457169 461221 465177 465745 466425 466664 466675 467133 469159 471593 476387 476744 477582 480066 483231 486425 486485 487095 487144 488212 488286 488565 490119 490462 491379 491641 491719 491721 496800 497661 499968 501306 504597 505236 505986 508828 508836 509765 510617 511704 512665 513290 513292 513302 513541 516379 518263 518397 521912 521928 522535 523510 524178 525640 527503 527511 527549 527620 533157 540482 544683 546015 551640 565361 565372 565414 565551 565561 566810 570030 570620 570639 570644 570661 571884 572499 572520 575117 575499 578059 578068 605318 611820 611900 638647 669609 669643 671409 672402 691607 723878 725563 729441 741175 748200 753907 769139 820677 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пикапе в"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пикап в"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.48%) |
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.