Query Metrics
7
Database Queries
7
Different statements
222.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
198.66 ms (89.21%) |
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 400435 400449 406064 418138 426680 429313 429325 429573 447928 462438 472765 473985 484097 485258 486826 490862 491651 491658 492986 501653 503935 511739 512828 512883 512884 513305 526463 527630 527632 527880 530205 531322 536125 538215 538386 540932 545711 545717 546603 557213 558840 559886 562269 563259 565769 571633 571649 573000 573419 573656 573666 573956 574502 574507 574511 574522 574538 574585 574823 574826 574841 574848 574884 575094 575109 575111 575115 575131 575162 575211 575461 575472 575474 575488 575494 575495 575514 575733 575734 575739 575757 575791 575795 576030 576052 576056 576061 576075 576343 576344 576364 576407 576414 576416 591383 591389 602932 610376 622405 625376 631167 634504 653494 666331 685425 693374 694585 697485 697885 701012 703967 727256 733672 759650 773683 789845 790508 804186 810987 820766 ] |
||||||||||||||||||||||||||||||
|
14.28 ms (6.41%) |
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 575094 576416 558840 576075 574511 574884 575733 631167 531322 530205 400435 406064 490862 576407 576414 545711 557213 565769 574502 574585 591389 759650 429313 418138 426680 472765 511739 512883 513305 527630 527880 484097 501653 526463 485258 492986 512828 527632 447928 462438 536125 486826 571649 575495 575757 546603 573666 573956 574848 575111 571633 666331 694585 697485 703967 653494 697885 685425 693374 573000 573419 573656 574522 575474 625376 602932 610376 634504 591383 789845 790508 727256 733672 773683 701012 804186 810987 429573 473985 400449 429325 512884 491651 538215 538386 562269 559886 574507 575472 503935 575115 575211 575488 575514 575795 576061 576364 545717 574841 575109 575791 576052 576056 576344 563259 574823 575131 575162 575739 576030 574538 574826 575461 575494 575734 576343 622405 491658 540932 820766 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.41%) |
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 400435 400449 406064 418138 426680 429313 429325 429573 447928 462438 472765 473985 484097 485258 486826 490862 491651 491658 492986 501653 503935 511739 512828 512883 512884 513305 526463 527630 527632 527880 530205 531322 536125 538215 538386 540932 545711 545717 546603 557213 558840 559886 562269 563259 565769 571633 571649 573000 573419 573656 573666 573956 574502 574507 574511 574522 574538 574585 574823 574826 574841 574848 574884 575094 575109 575111 575115 575131 575162 575211 575461 575472 575474 575488 575494 575495 575514 575733 575734 575739 575757 575791 575795 576030 576052 576056 576061 576075 576343 576344 576364 576407 576414 576416 591383 591389 602932 610376 622405 625376 631167 634504 653494 666331 685425 693374 694585 697485 697885 701012 703967 727256 733672 759650 773683 789845 790508 804186 810987 820766 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small porn"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая porn"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая porn"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.67%) |
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.