Query Metrics
7
Database Queries
7
Different statements
243.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
220.68 ms (90.78%) |
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 7308 7389 61226 135236 142853 161823 181043 181242 233344 323119 326017 382954 385054 386973 390583 392311 393855 394281 395425 395602 396279 397167 397888 413100 413165 420206 422653 424236 437988 440156 440818 443953 446083 449271 451786 452081 453243 453799 459571 460784 462245 462623 462826 467132 467522 468975 471679 478561 482260 488331 498480 500402 501154 502737 505363 506045 517047 517548 521474 522599 527304 528208 533776 545822 552414 562676 563193 585073 591004 593346 596760 596851 598407 604222 607413 615747 617000 617417 623394 637708 646105 646927 656386 664290 665487 668639 671222 674121 682675 683850 722968 723297 729225 742039 755375 757357 759904 759935 761052 764486 776860 778191 782235 784514 787173 789790 793070 796169 809135 810392 810614 816381 817731 817838 818069 818138 820191 820773 822161 824489 ] |
||||||||||||||||||||||||||||||
|
12.88 ms (5.30%) |
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 462623 467522 326017 453243 552414 598407 527304 462245 396279 386973 420206 817838 816381 818069 818138 820191 824489 822161 533776 656386 723297 683850 776860 778191 787173 784514 729225 759935 761052 385054 437988 7308 161823 615747 135236 233344 809135 604222 742039 323119 502737 668639 665487 664290 671222 682675 562676 789790 596851 500402 528208 451786 394281 646105 607413 142853 506045 395602 482260 471679 810392 392311 637708 722968 397888 397167 505363 422653 460784 462826 521474 452081 468975 393855 585073 674121 623394 796169 755375 810614 646927 596760 764486 424236 563193 757357 390583 443953 395425 498480 459571 478561 181043 440818 488331 545822 517047 449271 759904 181242 617000 446083 413165 517548 522599 593346 782235 793070 467132 7389 61226 501154 382954 591004 413100 820773 617417 453799 440156 817731 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.02%) |
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 7308 7389 61226 135236 142853 161823 181043 181242 233344 323119 326017 382954 385054 386973 390583 392311 393855 394281 395425 395602 396279 397167 397888 413100 413165 420206 422653 424236 437988 440156 440818 443953 446083 449271 451786 452081 453243 453799 459571 460784 462245 462623 462826 467132 467522 468975 471679 478561 482260 488331 498480 500402 501154 502737 505363 506045 517047 517548 521474 522599 527304 528208 533776 545822 552414 562676 563193 585073 591004 593346 596760 596851 598407 604222 607413 615747 617000 617417 623394 637708 646105 646927 656386 664290 665487 668639 671222 674121 682675 683850 722968 723297 729225 742039 755375 757357 759904 759935 761052 764486 776860 778191 782235 784514 787173 789790 793070 796169 809135 810392 810614 816381 817731 817838 818069 818138 820191 820773 822161 824489 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob stockings"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.63%) |
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.