Query Metrics
7
Database Queries
7
Different statements
175.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.63 ms (88.00%) |
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 10934 34353 147128 383362 384462 386918 387052 387115 388672 388962 389536 389994 397220 398865 411096 413163 414225 415760 415849 418160 420354 420900 434796 446519 448079 454131 454607 458627 463779 464186 468907 473514 476231 480513 492010 493834 495375 497809 499835 508237 509682 515253 515417 516468 518510 522617 522631 523485 525128 526427 527237 527541 535536 536146 536896 538157 538794 539589 540588 545896 546046 548373 549238 549331 552581 554185 554620 554823 555355 555747 556843 558300 559860 560443 562757 563114 565938 569225 569824 576254 577512 578478 581116 581158 590103 590110 596812 601932 602682 615233 617144 618306 618572 623965 625819 644160 644885 648670 653506 654333 682642 686133 686750 711773 731173 732220 735338 748272 752754 760176 760550 767008 772441 773158 782710 789317 792021 800784 804783 809005 ] |
||||||||||||||||||||||||||||||
|
12.63 ms (7.19%) |
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 782710 752754 773158 735338 625819 386918 458627 518510 415760 448079 515253 536146 523485 539589 545896 555355 560443 653506 602682 800784 760176 748272 767008 387052 576254 497809 516468 654333 549238 34353 526427 492010 581158 555747 590103 792021 10934 387115 383362 415849 644885 446519 454607 509682 515417 563114 578478 569824 581116 648670 644160 596812 623965 789317 732220 434796 388962 397220 418160 473514 538794 549331 577512 711773 686750 682642 546046 590110 615233 617144 760550 398865 420900 495375 147128 388672 389536 413163 411096 414225 463779 464186 480513 522631 525128 536896 540588 522617 527237 527541 493834 554823 556843 559860 562757 548373 554620 601932 618306 809005 804783 384462 389994 454131 552581 618572 476231 499835 558300 565938 554185 569225 686133 731173 772441 420354 468907 535536 538157 508237 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.23%) |
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 10934 34353 147128 383362 384462 386918 387052 387115 388672 388962 389536 389994 397220 398865 411096 413163 414225 415760 415849 418160 420354 420900 434796 446519 448079 454131 454607 458627 463779 464186 468907 473514 476231 480513 492010 493834 495375 497809 499835 508237 509682 515253 515417 516468 518510 522617 522631 523485 525128 526427 527237 527541 535536 536146 536896 538157 538794 539589 540588 545896 546046 548373 549238 549331 552581 554185 554620 554823 555355 555747 556843 558300 559860 560443 562757 563114 565938 569225 569824 576254 577512 578478 581116 581158 590103 590110 596812 601932 602682 615233 617144 618306 618572 623965 625819 644160 644885 648670 653506 654333 682642 686133 686750 711773 731173 732220 735338 748272 752754 760176 760550 767008 772441 773158 782710 789317 792021 800784 804783 809005 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс палец"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex finger"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс палец"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.72%) |
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.