Query Metrics
7
Database Queries
7
Different statements
185.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.07 ms (84.71%) |
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 14382 79331 130289 359067 383515 386758 388713 389987 396708 396746 397642 397849 397946 401340 401992 403141 405178 408074 408332 408458 414364 414448 414666 415591 425125 432813 445017 445741 449011 459830 462390 468694 476138 483734 488894 505103 517184 530912 532667 575792 575804 576053 576360 583371 604451 604570 612304 617411 629375 629423 632497 633563 635171 635215 635501 643666 643844 677783 697303 700158 703842 714549 725443 725510 725563 725712 727457 729293 729482 729570 730105 730441 730717 731302 731316 732002 732451 734073 734743 734795 735905 737259 738179 739637 739678 740466 740761 741571 742003 746598 747232 749034 750648 751681 753253 760180 764343 765473 765998 766245 767147 767162 769978 775913 787015 796424 800110 801355 802464 803376 803407 804023 805299 806145 807720 807784 807793 808684 812950 818439 ] |
||||||||||||||||||||||||||||||
|
17.12 ms (9.23%) |
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 803376 803407 805299 806145 725510 725563 725712 729293 729482 730105 730717 734795 737259 740761 741571 742003 749034 753253 769978 787015 796424 802464 804023 807720 725443 732451 738179 739678 740466 765473 765998 730441 731302 747232 751681 764343 766245 727457 729570 732002 734743 735905 760180 767147 767162 731316 734073 739637 746598 750648 604570 612304 629375 629423 632497 633563 635501 643666 643844 697303 700158 703842 775913 800110 801355 807784 807793 808684 812950 401992 79331 397642 383515 459830 532667 517184 530912 583371 677783 617411 635171 635215 425125 386758 130289 359067 388713 389987 396708 397849 397946 401340 403141 405178 408074 445017 408332 414364 414666 415591 408458 414448 432813 818439 468694 445741 462390 449011 488894 505103 476138 483734 575804 576360 575792 576053 604451 714549 14382 396746 ] |
||||||||||||||||||||||||||||||
|
4.00 ms (2.16%) |
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 14382 79331 130289 359067 383515 386758 388713 389987 396708 396746 397642 397849 397946 401340 401992 403141 405178 408074 408332 408458 414364 414448 414666 415591 425125 432813 445017 445741 449011 459830 462390 468694 476138 483734 488894 505103 517184 530912 532667 575792 575804 576053 576360 583371 604451 604570 612304 617411 629375 629423 632497 633563 635171 635215 635501 643666 643844 677783 697303 700158 703842 714549 725443 725510 725563 725712 727457 729293 729482 729570 730105 730441 730717 731302 731316 732002 732451 734073 734743 734795 735905 737259 738179 739637 739678 740466 740761 741571 742003 746598 747232 749034 750648 751681 753253 760180 764343 765473 765998 766245 767147 767162 769978 775913 787015 796424 800110 801355 802464 803376 803407 804023 805299 806145 807720 807784 807793 808684 812950 818439 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"порно межрасовое"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"порн межрасов"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.73%) |
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.