Query Metrics
7
Database Queries
7
Different statements
468.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
238.20 ms (50.86%) |
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 286389 348262 408326 416155 418088 421563 422028 422223 423955 426844 433211 435404 442335 443492 446425 449635 449778 453517 456886 459368 460767 461401 461811 464366 464658 470609 473115 480214 481249 485948 490063 496475 499497 516462 520206 520460 524535 525156 527667 542971 543974 544515 545099 548725 553428 555206 555696 555751 556561 559985 566055 566061 566295 568368 571797 571840 576904 576935 577996 578739 582708 583598 584660 585170 588794 590892 593849 595756 596176 596641 598633 599230 604251 606734 611588 611812 613246 617614 625776 628659 658810 660111 660435 675110 687259 701610 707434 709560 712243 718615 734537 747066 760181 771177 771182 771255 771609 775707 776582 780706 784717 789491 789571 790008 791356 792412 795028 795143 795148 795915 796193 797262 798622 799394 802947 805212 809481 812265 812387 812684 ] |
||||||||||||||||||||||||||||||
|
209.00 ms (44.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov licking"
]
|
||||||||||||||||||||||||||||||
|
12.79 ms (2.73%) |
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 525156 520206 464658 481249 485948 543974 548725 556561 568368 571797 553428 559985 566055 566061 571840 576904 584660 544515 545099 555206 576935 577996 658810 687259 712243 660111 660435 555696 578739 583598 613246 617614 596176 588794 598633 599230 611812 585170 590892 606734 611588 628659 784717 789571 795915 798622 812387 812684 775707 776582 795143 795148 760181 790008 791356 797262 802947 771255 747066 771177 771609 771182 780706 789491 792412 799394 805212 809481 812265 460767 416155 421563 459368 470609 480214 286389 423955 426844 435404 418088 461401 473115 453517 461811 499497 555751 701610 709560 718615 625776 596641 796193 795028 734537 582708 566295 707434 675110 604251 446425 433211 442335 449635 527667 520460 524535 542971 593849 595756 449778 464366 422028 516462 490063 348262 408326 422223 443492 456886 496475 ] |
||||||||||||||||||||||||||||||
|
3.44 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 286389 348262 408326 416155 418088 421563 422028 422223 423955 426844 433211 435404 442335 443492 446425 449635 449778 453517 456886 459368 460767 461401 461811 464366 464658 470609 473115 480214 481249 485948 490063 496475 499497 516462 520206 520460 524535 525156 527667 542971 543974 544515 545099 548725 553428 555206 555696 555751 556561 559985 566055 566061 566295 568368 571797 571840 576904 576935 577996 578739 582708 583598 584660 585170 588794 590892 593849 595756 596176 596641 598633 599230 604251 606734 611588 611812 613246 617614 625776 628659 658810 660111 660435 675110 687259 701610 707434 709560 712243 718615 734537 747066 760181 771177 771182 771255 771609 775707 776582 780706 784717 789491 789571 790008 791356 792412 795028 795143 795148 795915 796193 797262 798622 799394 802947 805212 809481 812265 812387 812684 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов лиза"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.36%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.29%) |
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.