Query Metrics
7
Database Queries
7
Different statements
179.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.20 ms (85.03%) |
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 401531 410272 413223 415077 419220 426259 456736 472659 491399 530465 533060 540262 547472 555004 555121 561445 565341 585726 591615 592428 592805 597898 600444 604306 604905 605320 606283 612188 632008 632289 634528 642659 645365 650312 651685 661657 663254 671725 672184 675276 676127 690144 691561 692813 695103 707308 709240 709594 710236 711628 715524 716784 717072 718041 720243 721910 724194 726602 732804 740473 747533 754208 756237 758213 758910 759867 759873 760616 760841 761555 765227 769894 775956 782562 783145 786197 787289 788131 788178 788585 788847 789953 789961 790958 795141 797728 798999 800296 800426 801909 802316 802514 804014 806201 811474 811490 811510 811989 812926 815151 815168 815180 815890 815905 815910 815939 816063 816886 816970 816991 817299 817318 818438 820840 820888 821238 821521 821551 822421 823466 ] |
||||||||||||||||||||||||||||||
|
16.39 ms (9.16%) |
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 675276 561445 597898 798999 801909 413223 540262 533060 555121 663254 720243 604905 632008 775956 782562 811490 724194 758910 754208 758213 632289 709240 787289 419220 604306 585726 812926 788178 820840 547472 645365 650312 651685 691561 695103 709594 721910 671725 672184 676127 710236 690144 711628 716784 717072 555004 592805 600444 605320 606283 786197 800296 802316 788585 788847 806201 732804 756237 789953 797728 804014 811510 759867 759873 726602 747533 761555 765227 740473 760616 634528 707308 718041 783145 789961 815180 815890 816063 816991 816886 821238 822421 815910 821521 530465 692813 715524 592428 795141 811989 760841 802514 811474 410272 816970 817318 820888 815905 815939 815151 815168 817299 818438 821551 823466 661657 591615 612188 642659 790958 788131 800426 769894 401531 426259 415077 491399 456736 472659 565341 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.74%) |
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 401531 410272 413223 415077 419220 426259 456736 472659 491399 530465 533060 540262 547472 555004 555121 561445 565341 585726 591615 592428 592805 597898 600444 604306 604905 605320 606283 612188 632008 632289 634528 642659 645365 650312 651685 661657 663254 671725 672184 675276 676127 690144 691561 692813 695103 707308 709240 709594 710236 711628 715524 716784 717072 718041 720243 721910 724194 726602 732804 740473 747533 754208 756237 758213 758910 759867 759873 760616 760841 761555 765227 769894 775956 782562 783145 786197 787289 788131 788178 788585 788847 789953 789961 790958 795141 797728 798999 800296 800426 801909 802316 802514 804014 806201 811474 811490 811510 811989 812926 815151 815168 815180 815890 815905 815910 815939 816063 816886 816970 816991 817299 817318 818438 820840 820888 821238 821521 821551 822421 823466 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"милфы в попу"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"милф анал"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.83%) |
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.