Query Metrics
7
Database Queries
7
Different statements
171.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.89 ms (81.75%) |
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 385092 421043 422078 422194 423969 424369 424873 428443 429782 430144 432990 435745 436577 442126 445905 448440 449722 449897 450319 450336 450786 451141 451380 453265 453437 454051 468396 473670 474129 474743 475091 477788 479473 479632 479842 480323 482997 484249 485179 486558 487654 488549 489737 490129 491061 491160 491607 493071 495584 497320 499604 499754 503383 506023 506527 508078 509384 509391 509570 509583 510174 510217 512451 515006 515010 516417 516444 517275 519825 520964 521316 521759 521807 524044 524274 524509 525586 525694 527130 527192 528100 545072 547824 551479 552757 552936 559791 563890 566089 567211 567362 567689 567910 568323 569559 571363 571976 574446 577474 578610 579695 584174 584414 584560 599376 604835 605708 606017 608425 608765 610209 615645 624045 653861 668472 675342 676209 682368 698282 764029 ] |
||||||||||||||||||||||||||||||
|
19.43 ms (11.35%) |
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 503383 508078 487654 491160 499604 506527 515010 524044 493071 506023 510174 525586 484249 551479 675342 764029 698282 385092 421043 515006 512451 423969 430144 435745 429782 424369 428443 436577 453437 475091 486558 449722 451141 491607 445905 454051 479842 509391 516444 525694 510217 521316 519825 509570 509583 524274 474129 477788 489737 563890 568323 578610 559791 552936 567689 569559 584174 676209 552757 566089 567362 579695 584560 599376 608425 615645 604835 608765 468396 479473 479632 442126 480323 422078 422194 473670 474743 432990 449897 453265 516417 485179 499754 490129 520964 527192 482997 488549 491061 495584 497320 524509 584414 574446 605708 610209 624045 521807 424873 450336 450786 448440 450319 451380 509384 517275 521759 527130 528100 567211 571363 577474 545072 547824 567910 682368 653861 668472 571976 606017 ] |
||||||||||||||||||||||||||||||
|
4.68 ms (2.73%) |
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 385092 421043 422078 422194 423969 424369 424873 428443 429782 430144 432990 435745 436577 442126 445905 448440 449722 449897 450319 450336 450786 451141 451380 453265 453437 454051 468396 473670 474129 474743 475091 477788 479473 479632 479842 480323 482997 484249 485179 486558 487654 488549 489737 490129 491061 491160 491607 493071 495584 497320 499604 499754 503383 506023 506527 508078 509384 509391 509570 509583 510174 510217 512451 515006 515010 516417 516444 517275 519825 520964 521316 521759 521807 524044 524274 524509 525586 525694 527130 527192 528100 545072 547824 551479 552757 552936 559791 563890 566089 567211 567362 567689 567910 568323 569559 571363 571976 574446 577474 578610 579695 584174 584414 584560 599376 604835 605708 606017 608425 608765 610209 615645 624045 653861 668472 675342 676209 682368 698282 764029 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov sleeping"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов спящ"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов спящ"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.86%) |
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.