Query Metrics
7
Database Queries
7
Different statements
149.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.94 ms (80.24%) |
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 226195 263299 384193 386638 392775 399250 399292 399367 401116 401559 402259 403556 413057 413174 413649 415256 416066 417232 417461 418868 419629 420111 420374 420901 422499 422501 422548 422695 422924 422982 425117 427221 432800 432802 434167 434208 444579 447257 447675 451741 451750 453621 454250 456341 456496 456802 457174 458777 462038 462306 464595 465980 467152 467296 471309 473924 475069 475505 475979 476381 477781 478381 481288 484088 489806 491193 492512 494369 495845 501874 503901 511691 512639 512762 513799 514789 515750 519064 519607 521373 522454 523025 523274 524146 524566 528429 529192 530244 546002 550332 556845 557745 558059 559198 560594 562148 562302 562375 564449 566224 567170 570638 573910 574808 575072 576027 576068 576071 576080 576292 588266 590186 598537 598854 601596 606697 620205 663239 720677 756080 ] |
||||||||||||||||||||||||||||||
|
18.64 ms (12.47%) |
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 575072 566224 576068 384193 401559 418868 481288 401116 413174 432802 478381 512639 492512 523274 226195 263299 422548 434208 419629 456341 475979 451750 467296 515750 558059 574808 560594 720677 546002 576292 588266 598854 417461 432800 471309 475069 399367 420901 444579 476381 416066 503901 519064 512762 521373 576080 399292 403556 417232 422501 413057 422982 447257 464595 456802 550332 573910 562375 576027 576071 564449 570638 556845 557745 590186 601596 756080 402259 447675 473924 475505 422499 425117 462306 465980 386638 420111 458777 477781 420374 453621 462038 524146 530244 501874 489806 511691 524566 529192 484088 494369 523025 606697 620205 663239 413649 513799 562302 422695 427221 422924 451741 457174 514789 559198 562148 567170 598537 392775 399250 434167 467152 415256 456496 454250 519607 522454 495845 528429 491193 ] |
||||||||||||||||||||||||||||||
|
3.72 ms (2.49%) |
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 226195 263299 384193 386638 392775 399250 399292 399367 401116 401559 402259 403556 413057 413174 413649 415256 416066 417232 417461 418868 419629 420111 420374 420901 422499 422501 422548 422695 422924 422982 425117 427221 432800 432802 434167 434208 444579 447257 447675 451741 451750 453621 454250 456341 456496 456802 457174 458777 462038 462306 464595 465980 467152 467296 471309 473924 475069 475505 475979 476381 477781 478381 481288 484088 489806 491193 492512 494369 495845 501874 503901 511691 512639 512762 513799 514789 515750 519064 519607 521373 522454 523025 523274 524146 524566 528429 529192 530244 546002 550332 556845 557745 558059 559198 560594 562148 562302 562375 564449 566224 567170 570638 573910 574808 575072 576027 576068 576071 576080 576292 588266 590186 598537 598854 601596 606697 620205 663239 720677 756080 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"старики ебуться с баб%…"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"старый секс женскийрод"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (1.04%) |
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.