Query Metrics
7
Database Queries
7
Different statements
169.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.77 ms (83.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 109082 271756 326205 341041 359260 360205 369353 382512 384288 385231 385288 385812 386316 388004 391833 391884 392002 392554 393245 395612 397064 397436 398242 400228 401814 408586 411727 411939 420485 443487 453171 453408 455202 456957 458680 459731 461671 461988 462074 462263 462527 462722 463196 463254 466344 468751 470598 470777 473918 474124 476515 477058 484326 489202 490005 496041 496328 496336 511879 518313 518563 523593 528447 538952 538955 541486 542226 544298 544323 548239 550429 551477 552617 552767 552820 553452 554183 554634 554646 554654 565826 566146 569089 572286 572748 574032 574235 581370 581399 592460 597079 599219 601172 603650 612875 629936 636229 639861 644213 648877 650320 663910 664302 665128 665134 665259 665271 666141 667525 669707 671296 693935 698398 720724 722670 723632 736509 789603 815463 819043 ] |
||||||||||||||||||||||||||||||
|
16.88 ms (9.94%) |
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 574032 544298 553452 541486 554654 664302 663910 665134 669707 722670 599219 629936 789603 612875 698398 391833 392554 397436 470777 473918 476515 385288 459731 463254 397064 456957 388004 400228 455202 462722 468751 466344 496336 477058 462527 518313 496328 528447 574235 551477 552617 566146 554646 462074 443487 453408 518563 490005 385812 386316 385231 109082 360205 398242 411727 723632 819043 815463 461671 462263 538952 538955 569089 554183 552767 665259 693935 650320 550429 552820 554634 601172 636229 644213 736509 359260 382512 408586 463196 393245 341041 384288 395612 461988 484326 496041 523593 391884 392002 271756 326205 369353 401814 420485 411939 453171 458680 470598 474124 489202 511879 542226 572286 581370 544323 548239 565826 581399 667525 720724 665128 648877 665271 666141 671296 572748 603650 639861 592460 597079 ] |
||||||||||||||||||||||||||||||
|
3.43 ms (2.02%) |
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 109082 271756 326205 341041 359260 360205 369353 382512 384288 385231 385288 385812 386316 388004 391833 391884 392002 392554 393245 395612 397064 397436 398242 400228 401814 408586 411727 411939 420485 443487 453171 453408 455202 456957 458680 459731 461671 461988 462074 462263 462527 462722 463196 463254 466344 468751 470598 470777 473918 474124 476515 477058 484326 489202 490005 496041 496328 496336 511879 518313 518563 523593 528447 538952 538955 541486 542226 544298 544323 548239 550429 551477 552617 552767 552820 553452 554183 554634 554646 554654 565826 566146 569089 572286 572748 574032 574235 581370 581399 592460 597079 599219 601172 603650 612875 629936 636229 639861 644213 648877 650320 663910 664302 665128 665134 665259 665271 666141 667525 669707 671296 693935 698398 720724 722670 723632 736509 789603 815463 819043 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"порно в село"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"порн деревня"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.95%) |
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.