Query Metrics
7
Database Queries
7
Different statements
199.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.60 ms (83.80%) |
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 386357 389110 404412 406204 409109 409258 419218 421119 422233 430285 438533 444815 448310 451983 453378 453513 454727 457953 461644 464557 464634 465500 467544 468538 471609 478952 479860 482079 482684 487712 489587 490184 501784 507549 509675 509720 510362 517663 521888 523871 525239 528066 543499 551293 551352 551359 555177 565218 576379 579290 586675 599669 607007 610202 612348 612412 613079 621527 623955 624731 624799 626891 628340 643424 644675 648587 650427 654152 654390 660242 660522 661148 661397 661759 663098 663483 663515 665578 668532 675448 683563 684150 689685 693528 695051 706921 716127 717119 717438 726277 734707 735019 737351 740325 743565 746473 749361 755362 755587 756227 757236 758719 770579 773027 779663 800775 805881 810366 811236 815145 815403 815622 815780 815824 816023 816429 816875 816967 823307 ] |
||||||||||||||||||||||||||||||
|
22.01 ms (11.01%) |
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 430285 454727 576379 624731 815780 684150 706921 683563 654152 660522 665578 800775 737351 743565 773027 726277 734707 757236 644675 543499 612348 816967 823307 551359 660242 650427 811236 438533 489587 551293 675448 626891 610202 586675 643424 756227 453513 389110 386357 421119 471609 487712 501784 509675 521888 510362 528066 621527 816429 648587 668532 663515 406204 482684 464557 663483 404412 523871 525239 409109 419218 478952 461644 467544 464634 490184 509720 816875 815824 815403 507549 717119 661148 805881 451983 551352 448310 555177 624799 612412 444815 479860 457953 465500 468538 453378 613079 623955 815622 815145 661397 716127 628340 735019 740325 769187 746473 755362 755587 749361 770579 717438 810366 695051 689685 693528 779663 579290 565218 599669 758719 607007 422233 482079 409258 517663 654390 816023 661759 663098 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (1.57%) |
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 386357 389110 404412 406204 409109 409258 419218 421119 422233 430285 438533 444815 448310 451983 453378 453513 454727 457953 461644 464557 464634 465500 467544 468538 471609 478952 479860 482079 482684 487712 489587 490184 501784 507549 509675 509720 510362 517663 521888 523871 525239 528066 543499 551293 551352 551359 555177 565218 576379 579290 586675 599669 607007 610202 612348 612412 613079 621527 623955 624731 624799 626891 628340 643424 644675 648587 650427 654152 654390 660242 660522 661148 661397 661759 663098 663483 663515 665578 668532 675448 683563 684150 689685 693528 695051 706921 716127 717119 717438 726277 734707 735019 737351 740325 743565 746473 749361 755362 755587 756227 757236 758719 770579 773027 779663 800775 805881 810366 811236 815145 815403 815622 815780 815824 816023 816429 816875 816967 823307 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage big cock"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"массаж большие cock"
]
|
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.