Query Metrics
7
Database Queries
7
Different statements
194.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.23 ms (85.52%) |
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 97401 387287 390565 401924 404342 405961 418534 421058 423655 427983 428301 429763 429764 452956 457963 477473 487129 499105 500348 522142 527411 530054 530491 530624 530766 531183 532792 532804 533949 534381 534650 536287 536344 537917 542213 542838 545718 549514 550196 550199 558714 561117 562535 571230 583707 583905 585102 591829 595719 599911 599950 599953 600008 600194 601625 601636 603269 604890 606499 617412 617414 617437 629411 630511 632046 632632 632655 633773 633787 634155 634812 636321 637022 637122 637125 640728 640742 640761 641681 641702 641950 641958 641977 642053 643376 644280 644910 645812 646178 647320 650161 651051 651135 660424 666907 668518 668525 668555 674984 676111 677295 678032 679326 679717 679742 679744 679803 680149 683262 684117 704269 704528 718970 737134 770205 790019 801923 805288 805558 811837 ] |
||||||||||||||||||||||||||||||
|
18.62 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 542838 591829 418534 423655 532804 534650 536287 530766 536344 530054 531183 534381 537917 550199 571230 583707 542213 545718 549514 583905 562535 646178 650161 676111 677295 679717 679742 679744 680149 704269 645812 651135 666907 674984 679326 679803 704528 651051 660424 668518 668555 678032 599911 606499 640728 640742 640761 641702 641950 600008 633787 634155 634812 637122 637125 601636 599950 599953 630511 641958 641977 642053 617412 617414 629411 632655 633773 641681 644280 805288 477473 428301 401924 429763 585102 644910 452956 487129 499105 500348 527411 684117 718970 683262 558714 595719 603269 604890 790019 811837 737134 770205 390565 404342 421058 405961 632632 427983 429764 530491 530624 532792 533949 561117 647320 550196 601625 636321 600194 643376 801923 805558 637022 457963 617437 97401 387287 632046 522142 668525 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.50%) |
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 97401 387287 390565 401924 404342 405961 418534 421058 423655 427983 428301 429763 429764 452956 457963 477473 487129 499105 500348 522142 527411 530054 530491 530624 530766 531183 532792 532804 533949 534381 534650 536287 536344 537917 542213 542838 545718 549514 550196 550199 558714 561117 562535 571230 583707 583905 585102 591829 595719 599911 599950 599953 600008 600194 601625 601636 603269 604890 606499 617412 617414 617437 629411 630511 632046 632632 632655 633773 633787 634155 634812 636321 637022 637122 637125 640728 640742 640761 641681 641702 641950 641958 641977 642053 643376 644280 644910 645812 646178 647320 650161 651051 651135 660424 666907 668518 668525 668555 674984 676111 677295 678032 679326 679717 679742 679744 679803 680149 683262 684117 704269 704528 718970 737134 770205 790019 801923 805288 805558 811837 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gangbang big ass"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"gangbang большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"gangbang большая большие жоп"
]
|
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.