Query Metrics
7
Database Queries
7
Different statements
245.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
217.80 ms (88.87%) |
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 395474 408841 410655 415203 417748 418713 419568 421520 429009 433553 434724 443467 443694 445011 447314 447316 447661 447850 448098 451015 451699 451872 459801 459832 465152 466179 470315 487862 490649 495358 505339 512295 517195 527607 540175 546292 550732 552131 552388 552645 560411 560662 561730 562286 564769 565044 565054 565055 565274 565953 566031 566526 566644 566836 567960 570494 570643 571558 573289 574841 575085 575131 575162 575202 575453 575485 576057 576110 576305 576332 579480 580236 581652 585990 586603 587858 590821 591032 591089 591349 595359 595441 596583 596629 597078 597233 597566 597964 598813 598923 600167 603584 603895 607125 629540 636816 640806 644674 659412 659413 709744 709781 712971 714449 716043 728260 731994 736614 742224 744973 751032 753449 758188 758563 766871 769796 784161 811210 817617 821855 ] |
||||||||||||||||||||||||||||||
|
16.66 ms (6.80%) |
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 731994 753449 728260 744973 758188 629540 709744 419568 585990 716043 550732 552645 712971 546292 591089 811210 766871 736614 751032 410655 451699 408841 470315 466179 448098 421520 565953 566031 574841 561730 565274 575131 575162 580236 659412 587858 603584 597566 590821 591349 596583 597233 600167 595359 640806 644674 714449 598813 512295 821855 552131 552388 564769 570494 575485 560662 565054 566836 573289 575085 575202 575453 576057 576332 560411 565044 565055 571558 576305 659413 562286 566526 567960 570643 581652 598923 607125 597078 742224 443694 451015 517195 579480 586603 418713 415203 447314 417748 817617 451872 447316 447850 459832 447661 490649 505339 540175 527607 566644 709781 591032 596629 636816 758563 769796 603895 784161 445011 433553 459801 465152 495358 395474 434724 443467 487862 576110 597964 595441 429009 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.19%) |
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 395474 408841 410655 415203 417748 418713 419568 421520 429009 433553 434724 443467 443694 445011 447314 447316 447661 447850 448098 451015 451699 451872 459801 459832 465152 466179 470315 487862 490649 495358 505339 512295 517195 527607 540175 546292 550732 552131 552388 552645 560411 560662 561730 562286 564769 565044 565054 565055 565274 565953 566031 566526 566644 566836 567960 570494 570643 571558 573289 574841 575085 575131 575162 575202 575453 575485 576057 576110 576305 576332 579480 580236 581652 585990 586603 587858 590821 591032 591089 591349 595359 595441 596583 596629 597078 597233 597566 597964 598813 598923 600167 603584 603895 607125 629540 636816 640806 644674 659412 659413 709744 709781 712971 714449 716043 728260 731994 736614 742224 744973 751032 753449 758188 758563 766871 769796 784161 811210 817617 821855 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые teen маленькая"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny teen small"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые teen маленькая"
]
|
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.