Query Metrics
7
Database Queries
7
Different statements
191.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.51 ms (86.59%) |
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 170215 382918 383430 398755 400134 400249 401799 409374 415299 417087 418292 429504 430433 430486 434219 434608 435734 435768 437305 437310 437583 438570 440645 442991 446031 451492 455281 460154 464866 481946 486081 486928 488907 494231 499121 500578 506127 507909 509598 512477 512483 518859 521361 523351 525728 528084 532004 532130 533959 536320 542090 549655 550643 550644 551646 552043 553277 555565 556397 558117 558176 559360 561002 561505 562517 563443 563920 575241 580007 581978 582269 586962 587915 589682 590396 590730 591155 593445 598375 599703 599803 600977 604419 611327 616978 620059 621724 621964 622668 640152 645939 663380 663929 670513 685023 710571 711354 714188 714378 715050 716535 716762 720545 729678 739985 751710 756920 777750 781924 788158 793997 799360 806742 807402 810718 813268 814376 824067 824953 825102 ] |
||||||||||||||||||||||||||||||
|
14.60 ms (7.64%) |
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 685023 788158 716535 825102 563920 720545 751710 793997 810718 398755 434219 532004 558117 551646 714188 486928 575241 481946 512483 549655 550644 559360 611327 715050 806742 807402 813268 440645 437583 587915 382918 438570 437305 824067 532130 536320 562517 553277 561002 550643 663929 670513 714378 777750 716762 383430 400134 521361 528084 442991 525728 435734 401799 582269 799360 824953 506127 509598 542090 621964 598375 620059 590396 781924 729678 418292 507909 488907 518859 645939 590730 430433 430486 739985 429504 756920 415299 437310 417087 499121 512477 555565 581978 640152 593445 409374 580007 711354 591155 663380 814376 446031 464866 561505 552043 616978 500578 710571 455281 563443 533959 599703 604419 434608 523351 556397 621724 460154 486081 558176 400249 451492 599803 435768 600977 589682 622668 586962 494231 170215 ] |
||||||||||||||||||||||||||||||
|
3.81 ms (2.00%) |
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 170215 382918 383430 398755 400134 400249 401799 409374 415299 417087 418292 429504 430433 430486 434219 434608 435734 435768 437305 437310 437583 438570 440645 442991 446031 451492 455281 460154 464866 481946 486081 486928 488907 494231 499121 500578 506127 507909 509598 512477 512483 518859 521361 523351 525728 528084 532004 532130 533959 536320 542090 549655 550643 550644 551646 552043 553277 555565 556397 558117 558176 559360 561002 561505 562517 563443 563920 575241 580007 581978 582269 586962 587915 589682 590396 590730 591155 593445 598375 599703 599803 600977 604419 611327 616978 620059 621724 621964 622668 640152 645939 663380 663929 670513 685023 710571 711354 714188 714378 715050 716535 716762 720545 729678 739985 751710 756920 777750 781924 788158 793997 799360 806742 807402 810718 813268 814376 824067 824953 825102 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step mom masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step mom мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step mom мастурбац"
]
|
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.