Query Metrics
7
Database Queries
7
Different statements
176.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.54 ms (82.99%) |
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 205 38135 117844 117905 373406 386938 389832 390389 390587 392100 397567 398074 398287 398300 398869 400707 401793 402239 415921 418201 418933 428956 429362 430520 432703 432982 434382 436836 439268 440780 443784 444431 444794 445099 446063 446785 452262 452880 453002 454133 454579 454655 460280 461704 464019 464023 466308 467010 467110 469455 469592 469845 471703 473428 473439 479708 479713 485246 486635 486845 493813 495501 495573 496126 498541 499252 503473 509995 510542 514854 520797 526167 529621 530436 536121 542989 545616 551494 559290 576439 576607 580397 589243 591043 591420 615692 632927 635701 650663 657565 658785 663306 670411 687315 693973 724285 733454 738499 742727 749172 754351 754399 754770 754800 757669 759755 766317 772548 774878 778246 783882 785748 786723 788577 792184 797856 803401 805990 811234 812598 ] |
||||||||||||||||||||||||||||||
|
20.14 ms (11.40%) |
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 401793 551494 510542 811234 418201 803401 400707 693973 754770 754800 446785 397567 205 485246 469455 454579 398300 446063 559290 461704 434382 498541 663306 432703 436836 576439 635701 38135 530436 589243 415921 576607 398074 657565 733454 805990 724285 390389 754399 402239 398869 418933 444794 520797 545616 469845 792184 486845 440780 467110 473428 687315 591043 785748 766317 591420 495573 467010 117844 389832 398287 428956 788577 754351 473439 529621 454655 464019 479713 742727 390587 632927 499252 514854 445099 453002 386938 496126 493813 443784 460280 466308 542989 444431 670411 797856 479708 615692 464023 503473 509995 430520 439268 452880 454133 526167 392100 471703 778246 774878 812598 432982 429362 373406 495501 452262 580397 650663 772548 738499 759755 783882 117905 486635 469592 536121 658785 749172 786723 757669 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.65%) |
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 205 38135 117844 117905 373406 386938 389832 390389 390587 392100 397567 398074 398287 398300 398869 400707 401793 402239 415921 418201 418933 428956 429362 430520 432703 432982 434382 436836 439268 440780 443784 444431 444794 445099 446063 446785 452262 452880 453002 454133 454579 454655 460280 461704 464019 464023 466308 467010 467110 469455 469592 469845 471703 473428 473439 479708 479713 485246 486635 486845 493813 495501 495573 496126 498541 499252 503473 509995 510542 514854 520797 526167 529621 530436 536121 542989 545616 551494 559290 576439 576607 580397 589243 591043 591420 615692 632927 635701 650663 657565 658785 663306 670411 687315 693973 724285 733454 738499 742727 749172 754351 754399 754770 754800 757669 759755 766317 772548 774878 778246 783882 785748 786723 788577 792184 797856 803401 805990 811234 812598 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"попа секс игрушки"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп секс игрушк"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.79%) |
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.