Query Metrics
7
Database Queries
7
Different statements
175.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.28 ms (81.63%) |
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 186416 351473 398237 400715 400723 400985 404125 404127 408776 424023 427449 443370 453603 453624 459811 462506 463093 469844 469898 485489 490791 495159 507009 507772 509077 509451 510586 514787 519321 524023 530347 541250 542942 548401 548670 552859 557964 562114 566886 571150 579234 579488 581206 583210 595470 595654 604425 609712 610174 617121 617848 621593 622037 623723 627171 631762 644708 658224 662436 675424 694129 698888 700945 702320 710001 714477 714851 716124 716392 718399 720818 720821 721449 733181 736866 736980 737910 738623 740084 740489 741114 743009 745386 747954 753548 753993 754967 759634 761862 762559 765763 765907 766644 771874 773024 773068 773098 775630 776138 776396 776915 784925 789870 789874 790168 793436 797247 800227 800305 801305 801644 803261 807663 810533 816764 817482 819212 824071 826672 ] |
||||||||||||||||||||||||||||||
|
16.43 ms (9.36%) |
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 824071 826672 801305 400985 631762 790168 427449 463093 485489 495159 583210 662436 604425 807663 579234 519321 557964 694129 718399 698888 720818 623723 789874 766644 773024 776396 776915 404125 507009 507772 510586 566886 714477 675424 720821 609712 644708 810533 738623 761862 747954 800227 801644 424023 404127 462506 400723 453624 490791 524023 777104 817482 459811 509077 530347 514787 548401 562114 658224 714851 700945 548670 552859 595470 595654 789870 803261 736980 737910 797247 800305 740489 754967 771874 773098 741114 753993 622037 453603 469844 469898 541250 186416 721449 509451 398237 408776 351473 400715 443370 819212 816764 542942 579488 581206 710001 716392 571150 610174 617121 617848 775630 776138 793436 733181 740084 784925 736866 759634 743009 753548 762559 745386 765763 765907 773068 621593 627171 702320 716124 ] |
||||||||||||||||||||||||||||||
|
5.07 ms (2.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер young девушк"
]
|
||||||||||||||||||||||||||||||
|
3.80 ms (2.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер young девушк"
]
|
||||||||||||||||||||||||||||||
|
3.77 ms (2.15%) |
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 186416 351473 398237 400715 400723 400985 404125 404127 408776 424023 427449 443370 453603 453624 459811 462506 463093 469844 469898 485489 490791 495159 507009 507772 509077 509451 510586 514787 519321 524023 530347 541250 542942 548401 548670 552859 557964 562114 566886 571150 579234 579488 581206 583210 595470 595654 604425 609712 610174 617121 617848 621593 622037 623723 627171 631762 644708 658224 662436 675424 694129 698888 700945 702320 710001 714477 714851 716124 716392 718399 720818 720821 721449 733181 736866 736980 737910 738623 740084 740489 741114 743009 745386 747954 753548 753993 754967 759634 761862 762559 765763 765907 766644 771874 773024 773068 773098 775630 776138 776396 776915 784925 789870 789874 790168 793436 797247 800227 800305 801305 801644 803261 807663 810533 816764 817482 819212 824071 826672 ] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam young girls"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.