Query Metrics
7
Database Queries
7
Different statements
202.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.91 ms (86.68%) |
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 214302 384419 384481 386954 391328 413898 415833 419951 420426 420657 425341 433930 436825 447909 453088 470230 472086 473562 474972 476595 478319 482013 487488 495761 502037 504259 506550 513292 518397 519115 525481 525810 529508 536079 543593 543851 543946 551172 554192 554642 556375 560164 569224 572824 573972 577957 578937 580978 589329 595086 598513 604789 610773 612990 615014 615184 618005 622022 627844 631136 634362 639218 643830 650228 658994 663893 677626 685525 690424 691834 696004 696009 699005 701604 704387 704447 708248 715874 718703 720474 724331 724790 726067 726886 729187 736430 736485 736489 736559 737541 745247 758036 760751 765886 766692 772529 773584 779634 779814 782133 786467 789067 791318 792351 794489 795424 798706 798944 799003 817969 818620 820515 820983 821438 821571 822274 822890 823343 826158 828123 ] |
||||||||||||||||||||||||||||||
|
15.63 ms (7.70%) |
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 577957 478319 518397 472086 572824 610773 627844 677626 639218 525481 729187 433930 386954 573972 504259 487488 543946 214302 828123 618005 391328 413898 529508 560164 718703 634362 773584 791318 701604 453088 818620 506550 820983 823343 820515 821438 821571 822274 822890 536079 578937 690424 704387 589329 798944 736559 760751 726886 745247 502037 519115 724331 789067 420657 525810 604789 513292 595086 779814 715874 622022 766692 685525 663893 696004 720474 631136 782133 543851 554642 384419 765886 799003 543593 708248 384481 476595 556375 615014 419951 415833 551172 470230 447909 704447 643830 650228 794489 696009 495761 758036 436825 736489 817969 615184 612990 795424 779634 798706 772529 736485 786467 420426 658994 569224 736430 737541 726067 482013 474972 425341 724790 598513 554192 580978 826158 473562 792351 691834 699005 ] |
||||||||||||||||||||||||||||||
|
3.90 ms (1.92%) |
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 214302 384419 384481 386954 391328 413898 415833 419951 420426 420657 425341 433930 436825 447909 453088 470230 472086 473562 474972 476595 478319 482013 487488 495761 502037 504259 506550 513292 518397 519115 525481 525810 529508 536079 543593 543851 543946 551172 554192 554642 556375 560164 569224 572824 573972 577957 578937 580978 589329 595086 598513 604789 610773 612990 615014 615184 618005 622022 627844 631136 634362 639218 643830 650228 658994 663893 677626 685525 690424 691834 696004 696009 699005 701604 704387 704447 708248 715874 718703 720474 724331 724790 726067 726886 729187 736430 736485 736489 736559 737541 745247 758036 760751 765886 766692 772529 773584 779634 779814 782133 786467 789067 791318 792351 794489 795424 798706 798944 799003 817969 818620 820515 820983 821438 821571 822274 822890 823343 826158 828123 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob public"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.80%) |
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.