Query Metrics
7
Database Queries
7
Different statements
176.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.83 ms (84.24%) |
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 177447 382025 382237 384327 388281 411608 413738 419051 419876 420133 429188 443229 445568 448630 461624 464716 468024 470359 475472 481719 489092 491673 507937 510232 514185 515070 519079 519693 524755 527932 528901 534269 534304 538622 541919 549858 550609 552319 554387 559696 561309 562886 564740 566859 568560 569409 573384 578041 584540 589200 591599 592555 603724 603833 604063 605314 605319 606703 617825 623203 623330 632654 635948 637133 644962 649114 654132 672588 678980 693166 701847 710956 720336 720382 720390 720840 726306 728210 733372 743396 746100 746182 748676 748816 755402 757442 758563 761546 761578 762627 769208 770883 771510 772799 777064 788510 793953 805181 805444 806215 809238 810681 810688 810696 810992 811009 811511 813384 814800 814864 816272 817023 818282 820420 821560 822271 822272 822694 822770 827420 ] |
||||||||||||||||||||||||||||||
|
17.65 ms (9.99%) |
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 761578 617825 413738 468024 420133 519079 177447 411608 470359 569409 464716 388281 461624 491673 578041 649114 605319 605314 733372 769208 772799 793953 761546 762627 419051 814800 489092 549858 561309 623330 726306 443229 827420 481719 519693 510232 527932 384327 382237 382025 419876 820420 822770 821560 814864 817023 818282 822694 816272 822271 822272 445568 475472 524755 515070 528901 534304 538622 534269 573384 566859 568560 710956 720382 720390 672588 678980 693166 654132 701847 720336 554387 592555 603833 604063 637133 589200 606703 777064 788510 805444 810681 810688 811009 811511 809238 813384 748676 748816 810992 728210 746182 757442 770883 743396 755402 758563 771510 746100 635948 805181 806215 810696 448630 429188 514185 623203 550609 552319 507937 720840 644962 559696 584540 541919 562886 564740 591599 632654 603724 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (1.79%) |
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 177447 382025 382237 384327 388281 411608 413738 419051 419876 420133 429188 443229 445568 448630 461624 464716 468024 470359 475472 481719 489092 491673 507937 510232 514185 515070 519079 519693 524755 527932 528901 534269 534304 538622 541919 549858 550609 552319 554387 559696 561309 562886 564740 566859 568560 569409 573384 578041 584540 589200 591599 592555 603724 603833 604063 605314 605319 606703 617825 623203 623330 632654 635948 637133 644962 649114 654132 672588 678980 693166 701847 710956 720336 720382 720390 720840 726306 728210 733372 743396 746100 746182 748676 748816 755402 757442 758563 761546 761578 762627 769208 770883 771510 772799 777064 788510 793953 805181 805444 806215 809238 810681 810688 810696 810992 811009 811511 813384 814800 814864 816272 817023 818282 820420 821560 822271 822272 822694 822770 827420 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina small cock"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская маленькая cock"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская маленькая cock"
]
|
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.