Query Metrics
7
Database Queries
7
Different statements
211.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.02 ms (84.71%) |
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 382057 384170 384470 393081 394338 395905 396934 400134 400493 400498 400888 402145 402599 403003 407187 409004 409093 410748 411591 411731 413112 413128 413463 417005 418974 421834 421853 421913 422165 422207 428840 430247 430393 432596 437361 437670 439717 440979 443183 443675 446306 448963 450995 452391 455183 457991 459131 463703 464382 464436 464559 465331 465366 465545 471609 472691 476904 477067 484052 491991 492138 493189 493198 493529 518944 519604 523031 523838 523902 524779 531974 532032 532054 532060 550330 551035 563436 579227 582656 591049 592856 593805 609825 613286 663772 663969 684308 699277 706266 710575 714752 715459 718558 720602 724295 727637 729678 732140 736393 742276 742638 746242 746267 758564 775129 782148 782626 786216 786280 787636 788804 793294 793930 796205 799357 799983 805714 807453 813771 816641 ] |
||||||||||||||||||||||||||||||
|
20.29 ms (9.60%) |
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 471609 714752 799357 782626 523838 440979 393081 813771 532032 582656 593805 807453 746242 732140 746267 410748 477067 411731 484052 609825 400493 439717 742276 418974 455183 519604 450995 394338 720602 396934 421913 782148 400888 413112 443183 464382 432596 816641 788804 409004 518944 532060 787636 758564 384170 663969 465545 613286 452391 464559 684308 793294 430393 400134 459131 409093 491991 402599 407187 786280 422165 422207 395905 729678 428840 411591 465331 742638 472691 523902 437670 736393 710575 382057 550330 403003 402145 563436 663772 464436 523031 493198 524779 457991 551035 786216 724295 430247 699277 715459 592856 799983 727637 476904 492138 493529 421853 437361 796205 417005 579227 413128 448963 591049 805714 793930 400498 421834 493189 413463 531974 532054 706266 775129 384470 443675 463703 465366 446306 718558 ] |
||||||||||||||||||||||||||||||
|
4.11 ms (1.94%) |
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 382057 384170 384470 393081 394338 395905 396934 400134 400493 400498 400888 402145 402599 403003 407187 409004 409093 410748 411591 411731 413112 413128 413463 417005 418974 421834 421853 421913 422165 422207 428840 430247 430393 432596 437361 437670 439717 440979 443183 443675 446306 448963 450995 452391 455183 457991 459131 463703 464382 464436 464559 465331 465366 465545 471609 472691 476904 477067 484052 491991 492138 493189 493198 493529 518944 519604 523031 523838 523902 524779 531974 532032 532054 532060 550330 551035 563436 579227 582656 591049 592856 593805 609825 613286 663772 663969 684308 699277 706266 710575 714752 715459 718558 720602 724295 727637 729678 732140 736393 742276 742638 746242 746267 758564 775129 782148 782626 786216 786280 787636 788804 793294 793930 796205 799357 799983 805714 807453 813771 816641 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother fuck son"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин секс son"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин секс son"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.