Query Metrics
7
Database Queries
7
Different statements
200.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.36 ms (86.51%) |
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 23524 23884 33689 62010 114640 197358 247545 383042 383069 386787 387072 387808 390445 395285 396893 397190 403181 409085 415548 418166 419100 423445 423468 424404 425549 426596 427148 436675 436838 436965 441206 446251 447647 448699 455324 457172 457205 460805 461250 464788 465542 465675 466016 471168 479486 480314 489381 495905 503648 506833 507547 517546 520917 523590 526995 531995 533731 547621 551963 552299 552594 552863 557031 558261 560576 587573 589799 592080 593690 608635 635703 635720 640488 649269 653273 654443 655295 664717 666494 667972 676433 680682 685637 689566 698647 699497 701910 706758 707217 707388 713080 719327 719807 723764 729292 731315 739604 742390 745954 748787 754843 754986 760632 766376 771933 774468 775720 776597 782526 784786 786545 790319 791710 792388 802196 803915 807070 809676 818440 827227 ] |
||||||||||||||||||||||||||||||
|
15.17 ms (7.57%) |
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 558261 62010 446251 386787 471168 667972 593690 784786 792388 754843 114640 466016 495905 395285 427148 465542 455324 457172 560576 552594 649269 655295 676433 664717 666494 698647 707388 592080 635703 775720 807070 766376 754986 729292 745954 771933 803915 383042 397190 425549 436965 423445 479486 448699 719327 776597 802196 760632 731315 640488 791710 436838 424404 461250 464788 507547 517546 387072 423468 531995 551963 713080 547621 809676 436675 247545 827227 706758 653273 699497 782526 383069 418166 523590 23884 197358 33689 403181 409085 415548 774468 465675 526995 533731 557031 701910 654443 680682 685637 589799 587573 790319 742390 748787 608635 460805 419100 426596 480314 447647 552863 552299 719807 396893 441206 520917 390445 457205 707217 689566 635720 723764 739604 387808 818440 786545 23524 506833 503648 489381 ] |
||||||||||||||||||||||||||||||
|
3.65 ms (1.82%) |
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 23524 23884 33689 62010 114640 197358 247545 383042 383069 386787 387072 387808 390445 395285 396893 397190 403181 409085 415548 418166 419100 423445 423468 424404 425549 426596 427148 436675 436838 436965 441206 446251 447647 448699 455324 457172 457205 460805 461250 464788 465542 465675 466016 471168 479486 480314 489381 495905 503648 506833 507547 517546 520917 523590 526995 531995 533731 547621 551963 552299 552594 552863 557031 558261 560576 587573 589799 592080 593690 608635 635703 635720 640488 649269 653273 654443 655295 664717 666494 667972 676433 680682 685637 689566 698647 699497 701910 706758 707217 707388 713080 719327 719807 723764 729292 731315 739604 742390 745954 748787 754843 754986 760632 766376 771933 774468 775720 776597 782526 784786 786545 790319 791710 792388 802196 803915 807070 809676 818440 827227 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bathroom fuck"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ван секс"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.96%) |
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.