Query Metrics
7
Database Queries
7
Different statements
398.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
372.09 ms (93.44%) |
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 34394 357513 387026 388087 391108 392104 395842 396707 397861 400818 400998 401005 401749 404600 405252 413126 417174 419145 421817 421824 421826 421834 421840 421847 421899 421936 423934 434044 439704 439802 440687 440826 442218 442238 442307 442773 442783 443105 443171 445873 447475 447961 448827 451850 453387 453701 457281 460651 462268 464256 465985 466941 468437 469736 470647 472159 473148 474092 475801 477881 478801 483450 483732 485386 489847 489971 490384 490513 492321 492449 498362 499025 499778 503169 509637 510783 512067 513133 515499 518325 518581 522657 523441 523762 523773 530790 532813 532903 532918 532943 549737 549739 560899 562001 562423 562977 570841 571501 576702 587167 624195 693308 725575 731751 731756 731769 731796 758438 761414 766911 781654 788209 790611 801450 802986 809932 816865 823769 826783 827059 ] |
||||||||||||||||||||||||||||||
|
16.39 ms (4.12%) |
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 790611 758438 781654 731756 731769 731796 725575 731751 801450 391108 827059 693308 761414 802986 357513 397861 387026 469736 532943 562001 624195 587167 395842 388087 396707 400818 401005 413126 440687 440826 442218 442238 442307 443171 434044 445873 447475 448827 447961 451850 457281 460651 462268 466941 474092 492449 498362 515499 499778 509637 523441 512067 522657 530790 532903 532918 464256 470647 472159 478801 492321 571501 549737 549739 560899 562423 562977 570841 576702 788209 809932 766911 404600 421840 423934 400998 401749 405252 417174 421824 421899 439802 465985 477881 419145 421817 421834 421847 442783 421936 439704 453387 468437 473148 421826 442773 443105 453701 475801 503169 518581 523773 483450 485386 490384 513133 518325 523762 532813 483732 489847 489971 490513 499025 510783 392104 34394 816865 823769 826783 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (0.71%) |
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 34394 357513 387026 388087 391108 392104 395842 396707 397861 400818 400998 401005 401749 404600 405252 413126 417174 419145 421817 421824 421826 421834 421840 421847 421899 421936 423934 434044 439704 439802 440687 440826 442218 442238 442307 442773 442783 443105 443171 445873 447475 447961 448827 451850 453387 453701 457281 460651 462268 464256 465985 466941 468437 469736 470647 472159 473148 474092 475801 477881 478801 483450 483732 485386 489847 489971 490384 490513 492321 492449 498362 499025 499778 503169 509637 510783 512067 513133 515499 518325 518581 522657 523441 523762 523773 530790 532813 532903 532918 532943 549737 549739 560899 562001 562423 562977 570841 571501 576702 587167 624195 693308 725575 731751 731756 731769 731796 758438 761414 766911 781654 788209 790611 801450 802986 809932 816865 823769 826783 827059 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"redhead mature"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рыжая mature"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рыжая mature"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.35%) |
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.