Query Metrics
7
Database Queries
7
Different statements
139.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.94 ms (82.84%) |
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 151179 154491 290366 387480 389794 404369 408880 413341 413641 414253 414595 416597 416700 416704 416707 416746 421993 424614 428235 439059 439195 444540 445413 448880 451266 452798 452878 453221 453223 455083 466476 470278 471455 474596 478442 481861 487200 495747 499936 510781 518470 530377 532755 534114 540868 541275 542524 542588 542590 542595 542701 545411 548153 550919 568267 574375 580188 580189 588071 590263 592418 597167 608076 609920 612070 615983 617969 628097 634106 635258 637544 639739 641999 644066 650157 650180 655242 660367 674043 674966 676026 677307 680199 688105 696594 696596 696607 720186 732035 735703 738483 738826 740409 741241 742459 745088 745100 745104 745106 745129 749075 749704 750426 752634 752645 752648 752670 754902 757905 770814 770821 775184 782792 782854 785589 788908 801275 803122 808746 817173 ] |
||||||||||||||||||||||||||||||
|
15.97 ms (11.41%) |
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 439059 451266 470278 518470 416746 428235 474596 548153 680199 592418 770821 801275 757905 445413 421993 650157 676026 650180 635258 677307 404369 452798 542590 542588 542595 588071 590263 471455 541275 487200 532755 542524 530377 639739 413641 495747 644066 674966 154491 151179 408880 414595 444540 414253 540868 817173 453223 481861 478442 510781 499936 534114 545411 574375 580189 550919 568267 580188 542701 660367 688105 696594 696607 720186 655242 674043 696596 617969 634106 608076 615983 628097 609920 637544 597167 785589 782792 782854 741241 770814 808746 732035 738826 740409 745129 750426 738483 742459 745088 745100 745106 749075 735703 745104 749704 752634 752645 752648 752670 754902 612070 641999 775184 788908 803122 389794 466476 416704 290366 387480 416707 424614 416700 413341 416597 439195 448880 452878 453221 455083 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.58%) |
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 151179 154491 290366 387480 389794 404369 408880 413341 413641 414253 414595 416597 416700 416704 416707 416746 421993 424614 428235 439059 439195 444540 445413 448880 451266 452798 452878 453221 453223 455083 466476 470278 471455 474596 478442 481861 487200 495747 499936 510781 518470 530377 532755 534114 540868 541275 542524 542588 542590 542595 542701 545411 548153 550919 568267 574375 580188 580189 588071 590263 592418 597167 608076 609920 612070 615983 617969 628097 634106 635258 637544 639739 641999 644066 650157 650180 655242 660367 674043 674966 676026 677307 680199 688105 696594 696596 696607 720186 732035 735703 738483 738826 740409 741241 742459 745088 745100 745104 745106 745129 749075 749704 750426 752634 752645 752648 752670 754902 757905 770814 770821 775184 782792 782854 785589 788908 801275 803122 808746 817173 ] |
||||||||||||||||||||||||||||||
|
1.53 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фистинг teen анал"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fisting teen anal"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"фистинг teen анал"
]
|
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.