Query Metrics
7
Database Queries
7
Different statements
155.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.88 ms (82.09%) |
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 6958 124661 134506 204605 206046 237986 238244 327502 331382 381993 382611 383475 383801 387279 388423 391206 400883 401004 402123 404084 404404 419590 420412 425931 428087 433542 433620 438058 443873 444136 445340 448738 450069 455186 455619 460124 462371 462821 462826 466038 466055 472940 473927 475427 475917 483230 485074 491351 501517 503974 505530 505935 505944 509167 515672 515688 515692 515706 515711 517081 520933 521174 522744 522961 523148 525619 526882 528673 530556 535328 538042 538973 542193 544586 545820 545909 546973 549164 553658 554791 559433 563131 564275 564640 568699 571378 571940 585473 585526 588326 589142 591823 596324 596928 600808 601255 601619 618985 619474 626945 630879 633674 642934 680625 687098 689318 695401 702294 711589 716231 717122 718764 759837 759972 760822 776856 778210 799034 805123 805292 ] |
||||||||||||||||||||||||||||||
|
16.82 ms (10.80%) |
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 526882 237986 718764 702294 805123 759972 238244 438058 535328 546973 433620 538973 448738 515711 445340 571940 585526 485074 545909 687098 134506 466055 554791 383801 563131 466038 433542 760822 515672 428087 542193 400883 404084 530556 571378 716231 601255 630879 600808 759837 717122 778210 420412 525619 383475 689318 520933 549164 553658 626945 444136 528673 402123 462821 425931 327502 503974 564640 559433 596324 206046 455186 680625 596928 501517 521174 462826 401004 522744 491351 589142 591823 450069 382611 404404 538042 601619 618985 799034 505935 588326 619474 483230 545820 711589 776856 805292 388423 475917 523148 515692 387279 509167 204605 443873 475427 472940 419590 515706 331382 124661 515688 695401 633674 381993 473927 6958 391206 642934 460124 505530 505944 462371 544586 564275 568699 585473 455619 522961 517081 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (2.05%) |
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 6958 124661 134506 204605 206046 237986 238244 327502 331382 381993 382611 383475 383801 387279 388423 391206 400883 401004 402123 404084 404404 419590 420412 425931 428087 433542 433620 438058 443873 444136 445340 448738 450069 455186 455619 460124 462371 462821 462826 466038 466055 472940 473927 475427 475917 483230 485074 491351 501517 503974 505530 505935 505944 509167 515672 515688 515692 515706 515711 517081 520933 521174 522744 522961 523148 525619 526882 528673 530556 535328 538042 538973 542193 544586 545820 545909 546973 549164 553658 554791 559433 563131 564275 564640 568699 571378 571940 585473 585526 588326 589142 591823 596324 596928 600808 601255 601619 618985 619474 626945 630879 633674 642934 680625 687098 689318 695401 702294 711589 716231 717122 718764 759837 759972 760822 776856 778210 799034 805123 805292 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"порно с секретаршей в …"
]
|
||||||||||||||||||||||||||||||
|
2.13 ms (1.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"порн секретарш в"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.06%) |
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.