Query Metrics
7
Database Queries
7
Different statements
207.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.02 ms (87.88%) |
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 4446 6694 6965 73289 91345 100685 108127 213118 233340 276780 356376 358566 358837 359441 365910 383443 383590 384762 384795 386323 388322 389273 389785 390445 391380 391703 393391 393504 395596 397912 397921 400865 401967 404078 414153 419517 419518 419523 421874 425052 425531 427197 428566 430818 439572 439745 442814 443278 443691 443754 444797 445056 457459 459070 459200 460745 461057 463177 465540 466138 466190 466272 468042 468344 470923 474265 475904 478546 489976 490812 496074 496724 496975 504038 515506 519180 523831 534670 536299 549102 554576 559857 561492 563438 563444 686158 698224 712311 715888 716090 717007 725185 726962 728259 730391 736398 736776 744184 744226 749009 756685 759556 759936 760953 767279 768392 770331 770417 775640 779804 785107 788983 795276 796134 800582 800721 801175 801253 801540 802144 ] |
||||||||||||||||||||||||||||||
|
16.25 ms (7.84%) |
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 459200 461057 388322 397921 459070 465540 443754 474265 504038 515506 489976 419523 439572 466138 478546 457459 443278 475904 386323 383590 359441 414153 698224 554576 744184 795276 445056 744226 384795 401967 561492 712311 389273 358566 391380 233340 391703 466190 496724 393391 468042 563438 563444 400865 460745 395596 419518 421874 419517 439745 442814 463177 425052 430818 466272 496074 496975 519180 523831 534670 490812 775640 384762 100685 393504 356376 73289 390445 397912 404078 425531 427197 536299 686158 717007 716090 549102 779804 785107 801175 801540 796134 800582 800721 801253 736776 726962 728259 736398 760953 770417 759556 725185 730391 756685 768392 749009 759936 767279 770331 715888 788983 802144 6694 91345 444797 468344 276780 6965 358837 365910 383443 389785 443691 470923 559857 213118 108127 4446 428566 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.10%) |
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 4446 6694 6965 73289 91345 100685 108127 213118 233340 276780 356376 358566 358837 359441 365910 383443 383590 384762 384795 386323 388322 389273 389785 390445 391380 391703 393391 393504 395596 397912 397921 400865 401967 404078 414153 419517 419518 419523 421874 425052 425531 427197 428566 430818 439572 439745 442814 443278 443691 443754 444797 445056 457459 459070 459200 460745 461057 463177 465540 466138 466190 466272 468042 468344 470923 474265 475904 478546 489976 490812 496074 496724 496975 504038 515506 519180 523831 534670 536299 549102 554576 559857 561492 563438 563444 686158 698224 712311 715888 716090 717007 725185 726962 728259 730391 736398 736776 744184 744226 749009 756685 759556 759936 760953 767279 768392 770331 770417 775640 779804 785107 788983 795276 796134 800582 800721 801175 801253 801540 802144 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"маму порн"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин порн"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.