Query Metrics
7
Database Queries
7
Different statements
167.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.49 ms (86.94%) |
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 73622 104130 358449 390112 394598 396932 401807 406339 413746 419619 419655 424129 428138 432532 439052 443117 443744 456311 456466 456591 457089 463382 465763 468707 470170 470422 472746 474956 476183 478168 481105 490278 490406 498702 508276 508750 510071 512901 514258 518412 521559 526291 528606 531212 533783 536286 549836 559737 571229 572326 590695 590707 592174 592961 597948 600317 603328 612079 632564 633472 633518 633814 634106 643121 644498 647996 649964 659315 668437 689693 694010 695125 702627 709240 710946 712053 712278 717859 720273 720743 722482 726638 732917 734493 744061 744842 745136 748690 748951 750608 750691 752566 752668 755630 759849 760007 760934 761583 764116 766605 768032 770213 775191 775269 783205 785591 785606 787438 789840 793497 798881 800608 804651 805242 814037 815013 815270 816687 819613 ] |
||||||||||||||||||||||||||||||
|
12.60 ms (7.53%) |
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 536286 514258 521559 571229 647996 695125 549836 572326 597948 785591 732917 748951 766605 770213 745136 760007 712278 722482 783205 419655 424129 443117 472746 465763 73622 432532 456591 463382 481105 390112 394598 428138 456466 474956 526291 528606 490278 490406 498702 508276 512901 510071 104130 815013 533783 531212 592961 590695 789840 761583 633814 457089 478168 826362 592174 603328 419619 600317 413746 816687 819613 815270 814037 470422 476183 468707 508750 559737 649964 668437 689693 659315 694010 717859 720743 710946 712053 720273 590707 634106 612079 643121 793497 804651 805242 787438 798881 800608 748690 785606 734493 750608 755630 759849 752566 764116 726638 744061 744842 750691 768032 633472 633518 644498 702627 709240 775191 775269 358449 406339 470170 456311 518412 396932 752668 760934 632564 401807 443744 439052 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.34%) |
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 73622 104130 358449 390112 394598 396932 401807 406339 413746 419619 419655 424129 428138 432532 439052 443117 443744 456311 456466 456591 457089 463382 465763 468707 470170 470422 472746 474956 476183 478168 481105 490278 490406 498702 508276 508750 510071 512901 514258 518412 521559 526291 528606 531212 533783 536286 549836 559737 571229 572326 590695 590707 592174 592961 597948 600317 603328 612079 632564 633472 633518 633814 634106 643121 644498 647996 649964 659315 668437 689693 694010 695125 702627 709240 710946 712053 712278 717859 720273 720743 722482 726638 732917 734493 744061 744842 745136 748690 748951 750608 750691 752566 752668 755630 759849 760007 760934 761583 764116 766605 768032 770213 775191 775269 783205 785591 785606 787438 789840 793497 798881 800608 804651 805242 814037 815013 815270 816687 819613 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pantyhose anal"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pantyhose анал"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pantyhose анал"
]
|
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.