Query Metrics
7
Database Queries
7
Different statements
192.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.12 ms (86.13%) |
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 89346 151179 209216 383238 384082 390587 392422 394514 396119 397478 397655 400571 408880 410702 411454 413418 414595 415859 415977 416737 419818 419998 423364 425610 427095 428473 429601 429692 429703 430347 432939 434367 436074 439146 439393 440217 443084 444531 444540 445787 446032 448057 452780 452792 452932 453209 455084 467110 468196 469139 469741 473213 475336 476932 477169 477759 487416 493700 493744 494495 495170 498226 499905 502770 502789 505327 505336 505385 505805 506086 506119 509958 510549 510766 511869 513528 514946 527921 531559 532381 532830 533594 533922 535277 540894 541858 545985 547241 547890 549549 555009 555407 556162 556167 558098 562048 562585 564500 566586 568262 572752 581210 582020 582032 584108 584323 598525 605746 610035 629047 633183 660578 660762 669303 679500 691204 742338 752589 803108 814467 ] |
||||||||||||||||||||||||||||||
|
16.81 ms (8.71%) |
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 505385 510549 535277 468196 493700 562048 566586 582020 582032 556162 564500 568262 541858 660762 679500 660578 691204 669303 545985 556167 584323 598525 633183 742338 752589 803108 397478 419818 452780 452932 384082 425610 440217 419998 469139 427095 429692 452792 513528 487416 495170 415859 444531 477759 547890 581210 629047 434367 506119 547241 610035 605746 436074 498226 383238 151179 209216 394514 392422 89346 390587 396119 397655 400571 413418 416737 423364 430347 408880 414595 439146 439393 443084 444540 411454 415977 429703 410702 428473 429601 432939 814467 448057 455084 469741 446032 467110 445787 453209 473213 476932 493744 499905 502789 505805 506086 509958 531559 532830 494495 510766 511869 532381 533594 533922 502770 505327 505336 514946 527921 475336 477169 540894 549549 555009 555407 558098 562585 572752 584108 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.35%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.22%) |
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 89346 151179 209216 383238 384082 390587 392422 394514 396119 397478 397655 400571 408880 410702 411454 413418 414595 415859 415977 416737 419818 419998 423364 425610 427095 428473 429601 429692 429703 430347 432939 434367 436074 439146 439393 440217 443084 444531 444540 445787 446032 448057 452780 452792 452932 453209 455084 467110 468196 469139 469741 473213 475336 476932 477169 477759 487416 493700 493744 494495 495170 498226 499905 502770 502789 505327 505336 505385 505805 506086 506119 509958 510549 510766 511869 513528 514946 527921 531559 532381 532830 533594 533922 535277 540894 541858 545985 547241 547890 549549 555009 555407 556162 556167 558098 562048 562585 564500 566586 568262 572752 581210 582020 582032 584108 584323 598525 605746 610035 629047 633183 660578 660762 669303 679500 691204 742338 752589 803108 814467 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"анусы соло"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анус соло"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.77%) |
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.