Query Metrics
7
Database Queries
7
Different statements
168.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.40 ms (85.50%) |
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 172262 285231 385931 400791 400826 406978 409261 409371 410029 410324 411685 413783 414138 414174 415573 417782 417927 420561 421204 421559 421665 422710 424970 427654 437867 446206 453138 454329 455569 456458 457341 459246 460514 460619 463832 464209 464404 464454 465512 466972 467155 468022 468730 468809 469023 469377 469465 471435 479767 480758 483150 485659 489472 490905 495385 496119 496935 499236 503441 505447 506016 506437 508131 509101 511219 511833 515363 515661 515970 517283 517579 517792 518019 518564 519622 520817 520930 521167 522608 522662 524117 528316 528952 536136 547815 562719 567222 569009 573298 580252 580839 582270 582487 582915 584566 593225 598846 601160 604723 605152 607014 608195 619703 621492 634688 636559 650544 700702 705536 716307 726810 747316 747475 756497 759892 759946 770228 770291 783291 814782 ] |
||||||||||||||||||||||||||||||
|
14.64 ms (8.67%) |
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 747475 726810 756497 770228 508131 467155 483150 406978 415573 459246 524117 471435 582270 409371 424970 400791 285231 422710 464404 417927 522608 518019 511833 511219 517579 582915 420561 417782 468022 453138 580839 547815 468809 456458 468730 410324 446206 517792 517283 520930 584566 562719 520817 605152 608195 636559 528952 621492 604723 783291 515970 410029 495385 567222 747316 700702 385931 455569 505447 409261 454329 469377 528316 536136 519622 460619 580252 573298 569009 593225 607014 598846 601160 634688 400826 466972 506016 496935 503441 522662 465512 469023 469465 490905 619703 414174 509101 521167 172262 413783 421665 411685 437867 814782 480758 515661 499236 464454 705536 716307 650544 582487 759892 770291 759946 421559 463832 464209 414138 421204 427654 457341 479767 460514 515363 489472 485659 506437 496119 518564 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.77%) |
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 172262 285231 385931 400791 400826 406978 409261 409371 410029 410324 411685 413783 414138 414174 415573 417782 417927 420561 421204 421559 421665 422710 424970 427654 437867 446206 453138 454329 455569 456458 457341 459246 460514 460619 463832 464209 464404 464454 465512 466972 467155 468022 468730 468809 469023 469377 469465 471435 479767 480758 483150 485659 489472 490905 495385 496119 496935 499236 503441 505447 506016 506437 508131 509101 511219 511833 515363 515661 515970 517283 517579 517792 518019 518564 519622 520817 520930 521167 522608 522662 524117 528316 528952 536136 547815 562719 567222 569009 573298 580252 580839 582270 582487 582915 584566 593225 598846 601160 604723 605152 607014 608195 619703 621492 634688 636559 650544 700702 705536 716307 726810 747316 747475 756497 759892 759946 770228 770291 783291 814782 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в чулках сексуальная %…"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чулк нижн бел сексуальн"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.91%) |
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.