Query Metrics
7
Database Queries
7
Different statements
187.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.47 ms (86.49%) |
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 39030 384325 385037 386304 386712 389310 391455 393456 393742 393775 395642 395654 396184 396191 396307 396894 396973 398390 399515 400485 400715 402090 403947 404127 404267 404845 405078 405288 411433 413748 415862 416764 418290 419674 422501 424569 425707 429338 429565 431768 442370 443381 444258 446375 452060 456909 458031 467329 469646 473955 477396 479324 480856 484088 492649 495147 501442 501461 511724 515118 520251 521854 522845 523172 523262 526037 527002 529206 550629 556412 557166 557304 559877 569668 569670 570072 570503 580399 586378 587297 588376 591418 598696 604417 613471 620200 631601 644654 663930 676525 696991 702904 710001 710604 710964 712722 721226 722676 722679 722919 723103 731037 732426 744296 747839 748136 751900 759565 759572 759596 759642 759652 770475 782223 787309 797578 800305 802397 802846 815855 ] |
||||||||||||||||||||||||||||||
|
15.86 ms (8.44%) |
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 759642 759572 404845 429338 523172 587297 396191 396307 393775 442370 747839 759652 744296 802846 385037 501461 721226 422501 484088 522845 393742 492649 604417 473955 511724 458031 570503 446375 770475 751900 480856 404267 429565 477396 787309 515118 732426 696991 456909 479324 722679 396973 722676 782223 395642 405288 425707 467329 419674 431768 443381 580399 598696 520251 529206 557166 415862 663930 402090 644654 393456 413748 389310 403947 527002 712722 800305 710964 521854 710604 586378 386304 418290 395654 399515 570072 569670 731037 411433 39030 396184 815855 404127 550629 469646 588376 613471 759565 702904 620200 759596 557304 559877 676525 591418 452060 400715 396894 398390 400485 495147 523262 384325 631601 748136 722919 569668 424569 710001 556412 802397 405078 386712 797578 391455 416764 501442 723103 444258 526037 ] |
||||||||||||||||||||||||||||||
|
2.65 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 39030 384325 385037 386304 386712 389310 391455 393456 393742 393775 395642 395654 396184 396191 396307 396894 396973 398390 399515 400485 400715 402090 403947 404127 404267 404845 405078 405288 411433 413748 415862 416764 418290 419674 422501 424569 425707 429338 429565 431768 442370 443381 444258 446375 452060 456909 458031 467329 469646 473955 477396 479324 480856 484088 492649 495147 501442 501461 511724 515118 520251 521854 522845 523172 523262 526037 527002 529206 550629 556412 557166 557304 559877 569668 569670 570072 570503 580399 586378 587297 588376 591418 598696 604417 613471 620200 631601 644654 663930 676525 696991 702904 710001 710604 710964 712722 721226 722676 722679 722919 723103 731037 732426 744296 747839 748136 751900 759565 759572 759596 759642 759652 770475 782223 787309 797578 800305 802397 802846 815855 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob old man"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс old мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс old мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.77%) |
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.