Query Metrics
7
Database Queries
7
Different statements
168.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.72 ms (81.64%) |
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 232940 383558 386864 387990 390601 393314 395580 398243 398712 407797 409532 410745 411291 411953 416298 422866 454289 456847 461260 462702 475020 479750 484558 497876 504354 508162 515153 515226 515724 520725 522574 530826 543415 550130 552617 558131 562826 563399 565096 565249 565367 574204 582789 589146 589571 590421 591599 591620 597263 597266 598057 600503 601114 603135 603147 605338 612427 614401 614407 617190 624179 624505 628366 628368 628376 628388 628391 633782 645891 646229 651188 663455 664321 665455 666540 666545 666550 666778 667230 671676 679444 679826 680112 680126 680186 688351 688624 692506 702164 704256 714436 716030 716032 726342 728191 730107 730233 731775 731814 733855 733884 743117 746079 748226 748240 748243 748531 750538 762257 775068 775972 776020 788604 789998 790382 806381 807399 808511 820331 821348 ] |
||||||||||||||||||||||||||||||
|
19.66 ms (11.66%) |
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 666540 666545 666550 680112 702164 651188 671676 680126 704256 591599 624505 598057 624179 628376 597263 628368 628388 617190 788604 748531 733855 633782 775972 462702 484558 552617 562826 716032 663455 688624 597266 733884 807399 614401 714436 515226 410745 776020 407797 515724 504354 574204 565249 563399 601114 603147 605338 716030 520725 515153 550130 565096 589571 390601 411291 743117 409532 454289 750538 387990 411953 820331 688351 612427 775068 398243 821348 479750 508162 665455 645891 666778 590421 603135 614407 806381 808511 748243 726342 398712 416298 475020 422866 456847 461260 664321 667230 692506 748226 790382 762257 728191 748240 386864 383558 522574 393314 395580 679444 589146 789998 746079 731814 731775 730107 232940 497876 680186 530826 679826 600503 628391 730233 558131 565367 591620 543415 582789 646229 628366 ] |
||||||||||||||||||||||||||||||
|
3.84 ms (2.28%) |
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 232940 383558 386864 387990 390601 393314 395580 398243 398712 407797 409532 410745 411291 411953 416298 422866 454289 456847 461260 462702 475020 479750 484558 497876 504354 508162 515153 515226 515724 520725 522574 530826 543415 550130 552617 558131 562826 563399 565096 565249 565367 574204 582789 589146 589571 590421 591599 591620 597263 597266 598057 600503 601114 603135 603147 605338 612427 614401 614407 617190 624179 624505 628366 628368 628376 628388 628391 633782 645891 646229 651188 663455 664321 665455 666540 666545 666550 666778 667230 671676 679444 679826 680112 680126 680186 688351 688624 692506 702164 704256 714436 716030 716032 726342 728191 730107 730233 731775 731814 733855 733884 743117 746079 748226 748240 748243 748531 750538 762257 775068 775972 776020 788604 789998 790382 806381 807399 808511 820331 821348 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young group sex"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young group секс"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young group секс"
]
|
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.