Query Metrics
7
Database Queries
7
Different statements
161.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.15 ms (79.47%) |
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 73280 386608 387693 401627 409021 412265 417662 419093 419311 422270 422272 422280 423351 425353 426535 430424 431749 432185 432837 433965 437322 444400 444739 448968 449225 449228 449243 450777 450830 454048 457016 457301 458462 463624 463630 464401 464412 464654 464921 472913 474447 477876 482168 483248 485798 486023 492615 494782 498456 510972 511804 513182 515678 515861 519957 521049 521166 523841 524774 525149 533568 540539 542449 542541 558868 564112 564127 564378 567081 568377 569003 569166 575721 584338 589573 591277 592810 600281 604197 614725 623978 625649 684975 707844 708844 747135 757340 758417 760721 764514 772021 772219 773799 773823 786523 789253 790504 797949 798622 800285 802117 807154 808675 812716 813416 815616 818009 819000 819533 821219 821283 821577 823336 824585 827305 827842 827857 827868 827869 827903 ] |
||||||||||||||||||||||||||||||
|
21.96 ms (13.62%) |
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 819000 821283 827868 827305 464401 409021 464654 423351 564127 567081 542449 684975 569166 614725 772021 772219 773799 764514 789253 790504 474447 519957 540539 758417 819533 591277 515861 401627 823336 821577 449225 584338 757340 449243 625649 464412 533568 773823 419311 485798 449228 521049 604197 786523 802117 808675 463624 426535 498456 511804 483248 515678 494782 821219 824585 827869 827857 457016 431749 422270 387693 386608 432837 707844 450777 812716 433965 492615 73280 575721 542541 564112 592810 797949 800285 425353 458462 482168 464921 430424 818009 827842 450830 525149 807154 747135 422280 564378 463630 486023 457301 477876 412265 513182 708844 760721 623978 444400 524774 510972 569003 589573 600281 521166 523841 417662 419093 444739 815616 827903 454048 448968 558868 568377 798622 813416 422272 432185 472913 437322 ] |
||||||||||||||||||||||||||||||
|
4.36 ms (2.70%) |
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 73280 386608 387693 401627 409021 412265 417662 419093 419311 422270 422272 422280 423351 425353 426535 430424 431749 432185 432837 433965 437322 444400 444739 448968 449225 449228 449243 450777 450830 454048 457016 457301 458462 463624 463630 464401 464412 464654 464921 472913 474447 477876 482168 483248 485798 486023 492615 494782 498456 510972 511804 513182 515678 515861 519957 521049 521166 523841 524774 525149 533568 540539 542449 542541 558868 564112 564127 564378 567081 568377 569003 569166 575721 584338 589573 591277 592810 600281 604197 614725 623978 625649 684975 707844 708844 747135 757340 758417 760721 764514 772021 772219 773799 773823 786523 789253 790504 797949 798622 800285 802117 807154 808675 812716 813416 815616 818009 819000 819533 821219 821283 821577 823336 824585 827305 827842 827857 827868 827869 827903 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde mom pov"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая mom пов"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"беловолосая mom пов"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.92%) |
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.