Query Metrics
7
Database Queries
7
Different statements
214.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
181.68 ms (84.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 403141 425206 426065 428723 450849 452048 452058 467635 468834 470200 470917 472019 482243 483162 484165 491449 492760 496097 499807 502305 506783 506790 509321 511023 514709 516686 520418 523423 529551 530010 530268 530624 530826 531134 532804 533043 534034 534631 534757 534986 535456 536532 536542 537747 537932 540944 541674 541725 541925 543419 543478 543576 550821 551041 551044 551046 551049 551994 554889 556747 557437 557439 561132 562773 562840 562842 562844 563534 565541 566246 566695 567581 568177 572599 573761 574464 581386 581890 583984 583996 584696 585716 586652 588298 589132 592444 596105 596464 599902 599908 599928 599934 599958 599988 600017 600270 600275 601585 601605 603210 603242 606566 607071 607108 609948 615883 619468 623231 642315 647600 674121 714938 729829 729881 746079 785421 806414 815112 815121 817344 ] |
||||||||||||||||||||||||||||||
|
22.18 ms (10.33%) |
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 674121 817344 450849 596105 509321 543419 499807 483162 551994 603242 562844 607108 472019 554889 541725 574464 584696 746079 566695 563534 599928 506790 511023 536542 531134 537932 647600 601605 600017 530826 403141 562842 729829 565541 815121 534034 556747 599958 785421 714938 586652 572599 516686 583996 484165 562840 452058 806414 470200 557437 581386 551049 609948 623231 541925 425206 529551 551041 551044 573761 581890 589132 606566 467635 603210 534631 534986 537747 815112 506783 557439 615883 729881 532804 533043 530268 543576 541674 600270 592444 491449 502305 543478 599934 601585 607071 642315 619468 426065 551046 452048 536532 520418 540944 561132 599908 534757 482243 468834 496097 492760 596464 428723 585716 599988 535456 514709 583984 568177 567581 588298 600275 599902 470917 550821 562773 566246 530010 530624 523423 ] |
||||||||||||||||||||||||||||||
|
3.82 ms (1.78%) |
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 403141 425206 426065 428723 450849 452048 452058 467635 468834 470200 470917 472019 482243 483162 484165 491449 492760 496097 499807 502305 506783 506790 509321 511023 514709 516686 520418 523423 529551 530010 530268 530624 530826 531134 532804 533043 534034 534631 534757 534986 535456 536532 536542 537747 537932 540944 541674 541725 541925 543419 543478 543576 550821 551041 551044 551046 551049 551994 554889 556747 557437 557439 561132 562773 562840 562842 562844 563534 565541 566246 566695 567581 568177 572599 573761 574464 581386 581890 583984 583996 584696 585716 586652 588298 589132 592444 596105 596464 599902 599908 599928 599934 599958 599988 600017 600270 600275 601585 601605 603210 603242 606566 607071 607108 609948 615883 619468 623231 642315 647600 674121 714938 729829 729881 746079 785421 806414 815112 815121 817344 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"худые мамки групповуха"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худая мам группов секс"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.