Query Metrics
7
Database Queries
7
Different statements
191.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.23 ms (84.38%) |
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 249873 392064 392805 396626 406472 419568 420491 421260 422460 429027 429121 429141 429146 429291 429431 434650 436642 436862 438536 446350 447632 451683 453633 457407 459913 461676 463202 463735 466848 466881 466882 467013 468769 469944 476990 478059 479564 483883 492147 492348 499307 501372 502916 512643 528988 539064 552151 552292 552633 552696 553094 555631 558231 558360 559474 560967 561069 561917 563299 564781 565177 565190 565831 566301 569875 570248 570276 570301 570338 570526 570528 570530 570647 570656 571191 571555 571780 571893 572116 572137 572151 572364 573051 573430 573648 573667 573685 573702 573720 573866 574532 575796 576333 577382 579375 580735 588615 596997 597535 602413 602662 603430 603459 614043 617201 633027 652129 702630 712459 745649 749440 756074 762843 763842 781633 790511 808314 810265 811528 814997 ] |
||||||||||||||||||||||||||||||
|
19.83 ms (10.38%) |
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 756074 745649 749440 762843 763842 702630 712459 781633 811528 434650 451683 249873 419568 392064 406472 512643 528988 392805 396626 420491 421260 429027 429146 429431 436642 438536 429141 422460 429121 436862 429291 814997 461676 469944 478059 492348 447632 466848 466881 467013 468769 476990 479564 446350 453633 457407 459913 463735 466882 483883 492147 501372 539064 502916 499307 463202 553094 564781 565831 569875 570526 572151 573430 573667 573702 573720 573866 575796 552292 559474 565177 570248 570338 570528 570530 570647 570656 576333 577382 579375 552151 552696 558360 561069 561917 563299 565190 570276 570301 571780 571893 572364 652129 552633 555631 558231 560967 566301 571191 571555 572116 572137 573051 573648 573685 574532 580735 602662 588615 602413 603459 617201 633027 596997 597535 603430 614043 808314 810265 790511 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.51%) |
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 249873 392064 392805 396626 406472 419568 420491 421260 422460 429027 429121 429141 429146 429291 429431 434650 436642 436862 438536 446350 447632 451683 453633 457407 459913 461676 463202 463735 466848 466881 466882 467013 468769 469944 476990 478059 479564 483883 492147 492348 499307 501372 502916 512643 528988 539064 552151 552292 552633 552696 553094 555631 558231 558360 559474 560967 561069 561917 563299 564781 565177 565190 565831 566301 569875 570248 570276 570301 570338 570526 570528 570530 570647 570656 571191 571555 571780 571893 572116 572137 572151 572364 573051 573430 573648 573667 573685 573702 573720 573866 574532 575796 576333 577382 579375 580735 588615 596997 597535 602413 602662 603430 603459 614043 617201 633027 652129 702630 712459 745649 749440 756074 762843 763842 781633 790511 808314 810265 811528 814997 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"18 19 мастурбац лет"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"18-летние мастурбация"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"18 19 мастурбац лет"
]
|
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.