Query Metrics
7
Database Queries
7
Different statements
156.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.58 ms (81.50%) |
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 382735 400892 418138 421780 423721 424255 428603 429445 439480 440838 440862 443091 449652 450158 450787 456858 457245 459972 461973 462266 472683 474809 475860 475907 475986 478060 480191 487753 490816 490862 495730 500794 506230 506940 507627 508431 510111 511820 513589 514131 515391 519335 521725 523296 526385 527175 527316 527772 528324 529174 530307 533653 534119 535050 537971 541396 542094 552798 554952 555701 558230 560438 561509 564488 565769 565771 565903 566371 573559 574387 574424 574562 575539 578255 579215 581213 588609 591494 591728 598466 598840 600476 604257 608645 619822 622785 622830 623085 625532 625771 627061 635050 650276 650605 651572 657177 660137 665990 671888 672752 677106 684029 696429 700590 700727 712763 716693 717410 724696 739900 740095 758268 763442 767018 773864 779591 780517 781779 783237 817230 ] |
||||||||||||||||||||||||||||||
|
17.88 ms (11.42%) |
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 514131 490816 500794 519335 515391 523296 527316 424255 487753 527772 560438 650605 552798 527175 573559 574562 700590 763442 740095 526385 542094 507627 440838 472683 622785 780517 428603 657177 724696 627061 382735 461973 510111 400892 439480 440862 443091 421780 423721 817230 449652 456858 474809 480191 450787 478060 490862 457245 459972 475986 495730 513589 528324 534119 521725 537971 508431 511820 529174 533653 506230 506940 530307 535050 541396 574424 575539 558230 565903 574387 578255 581213 554952 555701 564488 566371 650276 651572 660137 672752 700727 677106 684029 696429 717410 665990 671888 716693 561509 565769 565771 579215 591728 598840 608645 623085 619822 600476 604257 588609 591494 598466 625771 779591 783237 781779 767018 773864 758268 739900 622830 625532 635050 712763 429445 475860 475907 450158 418138 462266 ] |
||||||||||||||||||||||||||||||
|
3.51 ms (2.24%) |
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 382735 400892 418138 421780 423721 424255 428603 429445 439480 440838 440862 443091 449652 450158 450787 456858 457245 459972 461973 462266 472683 474809 475860 475907 475986 478060 480191 487753 490816 490862 495730 500794 506230 506940 507627 508431 510111 511820 513589 514131 515391 519335 521725 523296 526385 527175 527316 527772 528324 529174 530307 533653 534119 535050 537971 541396 542094 552798 554952 555701 558230 560438 561509 564488 565769 565771 565903 566371 573559 574387 574424 574562 575539 578255 579215 581213 588609 591494 591728 598466 598840 600476 604257 608645 619822 622785 622830 623085 625532 625771 627061 635050 650276 650605 651572 657177 660137 665990 671888 672752 677106 684029 696429 700590 700727 712763 716693 717410 724696 739900 740095 758268 763442 767018 773864 779591 780517 781779 783237 817230 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен porn"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife porn"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен porn"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.04%) |
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.