Query Metrics
7
Database Queries
7
Different statements
177.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.49 ms (86.69%) |
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 13118 152157 191254 320525 337012 379559 382591 385314 386608 388738 391704 408009 409877 413183 421740 422672 429609 434425 440817 440895 441207 444437 446630 448002 448710 450791 453735 457585 459778 464083 464235 464929 466196 466883 468434 468707 470404 472639 474794 478005 478455 478549 479369 479821 481328 482633 483114 485311 485646 486192 489271 489311 489953 493148 493575 493684 493778 499617 506031 508560 515909 525376 526456 530893 531556 532062 555093 561002 561453 564731 580712 586031 590621 592857 595425 604089 621700 634849 662140 668529 684916 694495 698733 714911 719929 721936 725353 725570 726612 727777 727789 733371 735027 735442 740826 740888 745630 746837 750250 752121 756678 756719 756863 758075 758509 760983 760992 761036 761323 761600 765299 772556 788868 789540 795750 800520 802151 805538 814906 817785 ] |
||||||||||||||||||||||||||||||
|
13.72 ms (7.75%) |
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 590621 595425 735027 789540 805538 756863 760983 761036 760992 740888 752121 756719 604089 386608 388738 448710 493148 385314 152157 191254 320525 382591 337012 409877 422672 408009 440817 429609 444437 814906 448002 468434 474794 450791 459778 466883 468707 470404 478005 479821 485646 489953 493684 446630 464083 464929 482633 483114 485311 515909 530893 531556 532062 508560 472639 564731 561002 662140 714911 668529 555093 561453 580712 592857 634849 802151 733371 758509 761323 761600 788868 726612 727789 740826 725570 765299 719929 795750 379559 481328 413183 434425 479369 391704 441207 478549 13118 457585 478455 421740 440895 453735 466196 499617 489271 486192 493778 525376 526456 489311 493575 506031 817785 464235 694495 684916 698733 721936 621700 586031 800520 725353 727777 746837 772556 735442 745630 750250 756678 758075 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.59%) |
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 13118 152157 191254 320525 337012 379559 382591 385314 386608 388738 391704 408009 409877 413183 421740 422672 429609 434425 440817 440895 441207 444437 446630 448002 448710 450791 453735 457585 459778 464083 464235 464929 466196 466883 468434 468707 470404 472639 474794 478005 478455 478549 479369 479821 481328 482633 483114 485311 485646 486192 489271 489311 489953 493148 493575 493684 493778 499617 506031 508560 515909 525376 526456 530893 531556 532062 555093 561002 561453 564731 580712 586031 590621 592857 595425 604089 621700 634849 662140 668529 684916 694495 698733 714911 719929 721936 725353 725570 726612 727777 727789 733371 735027 735442 740826 740888 745630 746837 750250 752121 756678 756719 756863 758075 758509 760983 760992 761036 761323 761600 765299 772556 788868 789540 795750 800520 802151 805538 814906 817785 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother cock"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин cock"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.