Query Metrics
7
Database Queries
7
Different statements
152.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.34 ms (80.37%) |
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 397960 400760 415957 418013 418163 419197 421991 423332 426358 427553 427845 430707 436314 437607 439769 439800 443533 443559 444853 445314 449029 449150 450339 455869 458914 459016 459482 461872 461890 464650 468705 470359 471908 472243 475390 475414 480708 481362 483145 483742 485325 489823 489980 495273 496033 496740 497757 498563 509869 510769 514113 515578 515605 518125 518501 518623 518627 520261 520781 522011 523404 523471 524406 524620 525356 526248 527738 530837 531120 532164 536387 539192 544803 545363 546311 549992 553302 553344 553703 553927 557449 558210 559203 568078 572259 575194 581530 583507 584907 584929 584945 586134 586976 587013 587035 587516 588722 589232 590088 592770 595011 601329 601485 605253 608447 610958 615762 625164 654201 656925 670758 680176 680197 702163 702168 812874 ] |
||||||||||||||||||||||||||||||
|
20.09 ms (13.20%) |
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 654201 439769 439800 443533 523404 427553 455869 559203 553344 483742 397960 459482 449029 586976 421991 527738 518501 546311 608447 520261 419197 445314 520781 523471 524406 587035 590088 587516 427845 400760 468705 423332 430707 472243 481362 485325 525356 496740 444853 475390 498563 541345 510769 518623 595011 625164 530837 515578 544803 615762 436314 471908 489823 461872 553927 588722 461890 483145 558210 557449 549992 581530 470359 610958 426358 459016 522011 539192 450339 480708 812874 458914 464650 553302 656925 584945 437607 415957 572259 418013 531120 587013 532164 670758 589232 443559 592770 518125 515605 475414 418163 518627 497757 702168 553703 568078 536387 584929 702163 495273 583507 449150 514113 575194 545363 680176 680197 605253 601329 601485 489980 584907 586134 526248 509869 496033 524620 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.90%) |
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 397960 400760 415957 418013 418163 419197 421991 423332 426358 427553 427845 430707 436314 437607 439769 439800 443533 443559 444853 445314 449029 449150 450339 455869 458914 459016 459482 461872 461890 464650 468705 470359 471908 472243 475390 475414 480708 481362 483145 483742 485325 489823 489980 495273 496033 496740 497757 498563 509869 510769 514113 515578 515605 518125 518501 518623 518627 520261 520781 522011 523404 523471 524406 524620 525356 526248 527738 530837 531120 532164 536387 539192 544803 545363 546311 549992 553302 553344 553703 553927 557449 558210 559203 568078 572259 575194 581530 583507 584907 584929 584945 586134 586976 587013 587035 587516 588722 589232 590088 592770 595011 601329 601485 605253 608447 610958 615762 625164 654201 656925 670758 680176 680197 702163 702168 812874 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex fit"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс fit"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс fit"
]
|
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.