Query Metrics
7
Database Queries
7
Different statements
144.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.49 ms (82.52%) |
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 39719 381966 385288 389979 396408 397843 410847 416163 418132 419155 420322 421290 421346 421990 422910 426666 426984 428027 429386 432395 432396 432412 432461 432464 432511 432622 433352 433385 433415 433676 435620 441427 452364 452538 453011 457749 460354 460356 460507 460868 461836 462027 465830 465835 465882 465915 465921 468240 469157 469632 473465 477476 478693 479677 480091 482588 482647 483240 486329 488160 491949 491977 491981 493308 498648 500149 500549 500890 503877 505992 509340 512515 520739 523893 526069 534393 534475 536084 536100 552112 554645 556201 558636 560334 561917 565831 569648 570833 572917 578328 580027 584440 591420 616989 618808 626642 627154 636719 638840 651700 662833 677847 703944 714395 721738 728169 731456 739156 744346 756480 757514 767989 768697 776032 788485 791036 793099 796476 811103 814206 ] |
||||||||||||||||||||||||||||||
|
14.83 ms (10.24%) |
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 491977 512515 491981 421346 416163 428027 435620 418132 814206 480091 457749 505992 536084 503877 536100 534475 486329 552112 565831 580027 572917 560334 561917 578328 677847 703944 714395 662833 721738 616989 636719 618808 591420 626642 638840 788485 776032 793099 796476 731456 744346 757514 739156 756480 767989 768697 627154 791036 811103 381966 426666 432395 432464 453011 460356 465830 478693 385288 389979 420322 421990 433676 460507 465835 465882 465921 469157 396408 397843 432412 460354 419155 426984 432396 452538 465915 433352 433385 433415 469632 473465 500149 500549 500890 488160 491949 498648 523893 483240 534393 728169 520739 429386 39719 432511 441427 421290 432461 410847 422910 432622 482647 460868 461836 477476 482588 452364 509340 526069 462027 468240 479677 493308 554645 569648 570833 558636 584440 556201 651700 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (2.00%) |
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 39719 381966 385288 389979 396408 397843 410847 416163 418132 419155 420322 421290 421346 421990 422910 426666 426984 428027 429386 432395 432396 432412 432461 432464 432511 432622 433352 433385 433415 433676 435620 441427 452364 452538 453011 457749 460354 460356 460507 460868 461836 462027 465830 465835 465882 465915 465921 468240 469157 469632 473465 477476 478693 479677 480091 482588 482647 483240 486329 488160 491949 491977 491981 493308 498648 500149 500549 500890 503877 505992 509340 512515 520739 523893 526069 534393 534475 536084 536100 552112 554645 556201 558636 560334 561917 565831 569648 570833 572917 578328 580027 584440 591420 616989 618808 626642 627154 636719 638840 651700 662833 677847 703944 714395 721738 728169 731456 739156 744346 756480 757514 767989 768697 776032 788485 791036 793099 796476 811103 814206 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"молодые в колготках и%…"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"молодые колготк"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.26%) |
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.