Query Metrics
7
Database Queries
7
Different statements
404.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.55 ms (51.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"куни в офисе"
]
|
||||||||||||||||||||||||||||||
|
171.04 ms (42.29%) |
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 12792 366052 383188 391359 397902 416965 422802 422815 425178 428531 428664 430876 431015 434838 441251 448818 451483 451524 460976 462424 463021 465390 466319 467139 467185 467218 471713 472511 472626 474104 479136 480787 483118 484984 485147 485346 486492 490872 490876 490942 491837 491901 491907 499816 500720 506845 511325 512172 512494 513436 515061 517565 519089 519683 520052 520660 521154 521168 524845 526877 530345 532983 533388 534309 541074 541637 544523 544525 544529 545676 553291 554573 558305 559601 560638 563191 563513 563521 565452 566075 572767 572838 575050 580073 580280 580424 581260 586469 588375 590518 592413 592590 594906 600826 601265 606608 607202 607466 608815 619466 623732 640521 645949 682618 696308 704557 712723 719067 719099 744311 753257 790501 798614 802117 802277 808527 814798 815148 815252 820173 ] |
||||||||||||||||||||||||||||||
|
16.06 ms (3.97%) |
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 513436 575050 704557 608815 790501 448818 485346 512172 815148 486492 519089 530345 506845 471713 491901 559601 541637 544523 719099 640521 422815 479136 466319 491907 383188 580073 712723 601265 366052 560638 554573 607466 397902 524845 485147 472626 428531 594906 533388 753257 491837 607202 565452 391359 499816 467139 814798 534309 719067 586469 798614 588375 428664 520052 441251 517565 500720 544525 553291 645949 580424 563513 520660 451483 12792 572838 600826 416965 462424 619466 682618 590518 802117 465390 815252 467185 581260 563521 802277 422802 521168 545676 592590 515061 521154 572767 808527 474104 480787 463021 526877 490942 467218 460976 519683 434838 512494 511325 696308 563191 606608 592413 430876 490872 490876 472511 566075 451524 484984 431015 623732 544529 425178 532983 541074 820173 483118 580280 744311 558305 ] |
||||||||||||||||||||||||||||||
|
3.43 ms (0.85%) |
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 12792 366052 383188 391359 397902 416965 422802 422815 425178 428531 428664 430876 431015 434838 441251 448818 451483 451524 460976 462424 463021 465390 466319 467139 467185 467218 471713 472511 472626 474104 479136 480787 483118 484984 485147 485346 486492 490872 490876 490942 491837 491901 491907 499816 500720 506845 511325 512172 512494 513436 515061 517565 519089 519683 520052 520660 521154 521168 524845 526877 530345 532983 533388 534309 541074 541637 544523 544525 544529 545676 553291 554573 558305 559601 560638 563191 563513 563521 565452 566075 572767 572838 575050 580073 580280 580424 581260 586469 588375 590518 592413 592590 594906 600826 601265 606608 607202 607466 608815 619466 623732 640521 645949 682618 696308 704557 712723 719067 719099 744311 753257 790501 798614 802117 802277 808527 814798 815148 815252 820173 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куннилингус оральн секс секретарш"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.38%) |
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.