Query Metrics
7
Database Queries
7
Different statements
209.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.68 ms (87.35%) |
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 22984 187803 290150 384857 388522 392937 396414 405129 416832 422336 423837 424402 425008 426480 428388 428406 428702 432727 432735 436730 445977 446481 446508 447366 447867 448044 449053 450633 451033 454537 454765 458260 459217 460030 460659 461358 461472 462193 465875 466384 468959 472323 474145 474999 475376 476085 478985 479272 486960 491078 494641 495324 496936 505746 505988 507737 509118 509549 512180 512688 516656 517027 517167 521425 521946 523370 523972 526147 526407 527341 532018 538193 541427 543129 547884 550495 551575 559671 564082 564275 565390 568113 574442 575392 578067 578642 580035 580217 582036 589331 589799 590407 590689 591380 592143 594979 596997 599195 599588 599949 605534 606833 608534 612904 613415 625176 629594 636409 638187 639219 662562 690684 691980 754209 754790 794107 800307 801791 808277 811907 ] |
||||||||||||||||||||||||||||||
|
14.19 ms (6.79%) |
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 639219 447366 474145 494641 505746 495324 517027 517167 564082 590689 591380 594979 428388 468959 392937 638187 589331 629594 423837 507737 754209 521425 580035 605534 445977 509118 466384 541427 465875 446481 384857 405129 461358 801791 811907 526407 543129 575392 599588 475376 454537 474999 565390 580217 606833 428406 608534 512688 532018 551575 547884 574442 22984 509549 496936 613415 450633 516656 491078 527341 432727 432735 446508 505988 523972 512180 568113 564275 690684 662562 636409 592143 800307 478985 472323 459217 425008 436730 479272 451033 526147 538193 422336 460030 550495 582036 559671 590407 599195 596997 290150 461472 462193 794107 599949 416832 428702 521946 691980 625176 589799 424402 476085 523370 578067 612904 486960 388522 426480 447867 578642 454765 460659 396414 808277 754790 187803 449053 458260 448044 ] |
||||||||||||||||||||||||||||||
|
3.97 ms (1.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вагин туалет"
]
|
||||||||||||||||||||||||||||||
|
2.48 ms (1.18%) |
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 22984 187803 290150 384857 388522 392937 396414 405129 416832 422336 423837 424402 425008 426480 428388 428406 428702 432727 432735 436730 445977 446481 446508 447366 447867 448044 449053 450633 451033 454537 454765 458260 459217 460030 460659 461358 461472 462193 465875 466384 468959 472323 474145 474999 475376 476085 478985 479272 486960 491078 494641 495324 496936 505746 505988 507737 509118 509549 512180 512688 516656 517027 517167 521425 521946 523370 523972 526147 526407 527341 532018 538193 541427 543129 547884 550495 551575 559671 564082 564275 565390 568113 574442 575392 578067 578642 580035 580217 582036 589331 589799 590407 590689 591380 592143 594979 596997 599195 599588 599949 605534 606833 608534 612904 613415 625176 629594 636409 638187 639219 662562 690684 691980 754209 754790 794107 800307 801791 808277 811907 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пися туалет"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин туалет"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.