Query Metrics
7
Database Queries
7
Different statements
187.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.50 ms (87.66%) |
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 34382 410203 414643 419293 419631 420353 420367 420369 420381 421732 421982 431893 431904 432928 437193 437368 444074 444424 447005 448103 448503 448867 452890 452892 453030 453032 453226 453228 457174 457179 457183 457653 457958 457971 460863 461234 464343 464982 465611 468726 469997 470418 470555 470858 476274 478582 480135 481126 482314 482698 484271 486383 487368 487543 502756 502762 509078 510953 515023 515364 515725 515805 516514 521559 524614 530109 530452 531700 536390 541103 544305 545455 545624 545854 550314 550530 556072 561313 565252 565280 566656 569020 577990 579790 580166 580182 581500 582301 582321 582849 583035 612070 630380 702627 705737 709198 711685 718928 722812 722864 726635 751094 751128 751150 751159 757431 761129 761992 774214 780567 784153 786471 797328 798351 802594 810991 813273 816565 818206 ] |
||||||||||||||||||||||||||||||
|
13.27 ms (7.07%) |
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 813273 751159 774214 726635 761992 751128 751150 757431 751094 761129 612070 630380 702627 705737 722812 722864 780567 784153 786471 797328 798351 802594 810991 453226 457958 470555 444424 452890 452892 468726 478582 480135 410203 419293 420369 457653 457971 469997 414643 420367 437193 444074 448503 509078 516514 487368 502756 515725 502762 524614 510953 536390 556072 453030 579790 709198 437368 464982 460863 34382 420381 421732 431893 431904 432928 419631 420353 421982 816565 818206 482698 447005 448103 448867 453032 470418 470858 481126 484271 453228 457174 457179 461234 464343 486383 457183 482314 487543 515023 515364 515805 530452 521559 530109 531700 465611 476274 541103 544305 545455 565252 566656 569020 580166 580182 582849 545624 561313 581500 582321 545854 550314 550530 552409 565280 577990 582301 583035 711685 718928 ] |
||||||||||||||||||||||||||||||
|
3.30 ms (1.76%) |
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 34382 410203 414643 419293 419631 420353 420367 420369 420381 421732 421982 431893 431904 432928 437193 437368 444074 444424 447005 448103 448503 448867 452890 452892 453030 453032 453226 453228 457174 457179 457183 457653 457958 457971 460863 461234 464343 464982 465611 468726 469997 470418 470555 470858 476274 478582 480135 481126 482314 482698 484271 486383 487368 487543 502756 502762 509078 510953 515023 515364 515725 515805 516514 521559 524614 530109 530452 531700 536390 541103 544305 545455 545624 545854 550314 550530 556072 561313 565252 565280 566656 569020 577990 579790 580166 580182 581500 582301 582321 582849 583035 612070 630380 702627 705737 709198 711685 718928 722812 722864 726635 751094 751128 751150 751159 757431 761129 761992 774214 780567 784153 786471 797328 798351 802594 810991 813273 816565 818206 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"порно мультики смотреть"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"порн мультфильм смотрет"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.