Query Metrics
7
Database Queries
7
Different statements
161.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.29 ms (83.25%) |
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 382594 388976 395751 395923 395959 395984 397129 398801 399058 399250 399253 401655 404318 404753 404765 409958 415200 415256 416066 418049 418648 418867 422925 425878 426152 431231 432802 447809 451596 452828 453228 453793 462470 463815 465180 469531 472426 473182 476409 477078 478459 482080 483500 484088 489516 491640 492163 510689 512639 512883 515269 515279 520736 523205 523274 523985 528903 529855 532843 533471 539210 540334 541076 545717 546200 558131 561816 565162 565254 565262 568573 569677 569692 573774 574606 575059 575737 576412 595873 597028 598498 598553 598745 606798 619571 623203 627725 627804 627813 627814 628363 628419 632689 633497 633733 640772 642691 647343 650158 659409 664976 666868 680167 680182 692001 694131 702166 702168 716043 720056 720422 722867 744135 751770 791181 811439 811628 812354 813902 818390 ] |
||||||||||||||||||||||||||||||
|
18.24 ms (11.31%) |
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 399250 418648 418867 422925 469531 415256 451596 465180 477078 395923 395959 399253 409958 432802 472426 416066 431231 510689 512883 512639 515279 515269 484088 523274 533471 565254 558131 702166 463815 489516 818390 694131 692001 791181 744135 395751 426152 462470 452828 478459 576412 561816 659409 720056 680167 565162 598498 595873 597028 632689 633733 642691 606798 628419 640772 812354 619571 716043 415200 425878 482080 404318 473182 520736 523985 627725 666868 568573 569677 569692 575737 627804 811628 627813 395984 483500 453228 540334 575059 447809 491640 545717 453793 573774 574606 598553 529855 539210 382594 398801 813902 528903 664976 722867 720422 811439 751770 388976 476409 702168 565262 627814 633497 532843 523205 541076 647343 680182 650158 546200 598745 623203 628363 492163 397129 399058 401655 404765 404753 418049 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.55%) |
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 382594 388976 395751 395923 395959 395984 397129 398801 399058 399250 399253 401655 404318 404753 404765 409958 415200 415256 416066 418049 418648 418867 422925 425878 426152 431231 432802 447809 451596 452828 453228 453793 462470 463815 465180 469531 472426 473182 476409 477078 478459 482080 483500 484088 489516 491640 492163 510689 512639 512883 515269 515279 520736 523205 523274 523985 528903 529855 532843 533471 539210 540334 541076 545717 546200 558131 561816 565162 565254 565262 568573 569677 569692 573774 574606 575059 575737 576412 595873 597028 598498 598553 598745 606798 619571 623203 627725 627804 627813 627814 628363 628419 632689 633497 633733 640772 642691 647343 650158 659409 664976 666868 680167 680182 692001 694131 702166 702168 716043 720056 720422 722867 744135 751770 791181 811439 811628 812354 813902 818390 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny young teen"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые young teen"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые young teen"
]
|
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.