Query Metrics
7
Database Queries
7
Different statements
172.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.63 ms (85.51%) |
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 395856 417064 417891 418879 419867 419880 424569 425523 428509 429369 431429 431962 432149 433231 439598 441191 442864 443153 445668 446735 446984 447625 449311 449778 449784 452097 454107 462904 465353 465354 465844 466972 467036 467721 468957 469200 480719 483569 484127 484129 486237 487902 492921 496784 496862 496870 496935 500375 500482 500504 503376 505460 505693 507961 508516 510365 512514 514309 514645 517612 518072 518917 523537 523636 526588 526718 527454 527989 532419 533541 539288 542754 544261 545444 545538 545545 548606 552588 554388 561351 564867 571958 572711 575472 575532 576325 578531 578587 579368 581852 584461 591413 593742 596556 601669 602562 602928 604061 604097 606482 615735 615774 619516 622981 623212 623306 623792 625000 634484 641644 641901 645918 653458 670955 673522 674064 693269 711283 790223 807707 ] |
||||||||||||||||||||||||||||||
|
16.55 ms (9.58%) |
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 670955 693269 673522 622981 623212 602562 593742 615774 807707 790223 641901 469200 447625 466972 417891 442864 449311 510365 514309 492921 484127 496784 496935 503376 526588 507961 523636 572711 417064 431962 433231 445668 486237 517612 527454 500504 518917 500482 542754 548606 575532 544261 545545 561351 578531 579368 581852 674064 554388 571958 575472 604097 596556 604061 615735 591413 625000 623792 418879 395856 424569 439598 443153 465353 468957 505693 512514 487902 500375 584461 429369 431429 484129 446735 467036 527989 532419 505460 462904 545538 576325 564867 653458 578587 619516 623306 641644 432149 465354 467721 428509 441191 446984 465844 508516 483569 496862 496870 449784 452097 480719 454107 518072 523537 533541 552588 711283 601669 606482 634484 602928 449778 425523 419867 419880 514645 539288 526718 545444 645918 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.35%) |
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 395856 417064 417891 418879 419867 419880 424569 425523 428509 429369 431429 431962 432149 433231 439598 441191 442864 443153 445668 446735 446984 447625 449311 449778 449784 452097 454107 462904 465353 465354 465844 466972 467036 467721 468957 469200 480719 483569 484127 484129 486237 487902 492921 496784 496862 496870 496935 500375 500482 500504 503376 505460 505693 507961 508516 510365 512514 514309 514645 517612 518072 518917 523537 523636 526588 526718 527454 527989 532419 533541 539288 542754 544261 545444 545538 545545 548606 552588 554388 561351 564867 571958 572711 575472 575532 576325 578531 578587 579368 581852 584461 591413 593742 596556 601669 602562 602928 604061 604097 606482 615735 615774 619516 622981 623212 623306 623792 625000 634484 641644 641901 645918 653458 670955 673522 674064 693269 711283 790223 807707 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"best pussy"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"best pussy"
]
|
||||||||||||||||||||||||||||||
|
1.25 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"best pussy"
]
|
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.