Query Metrics
7
Database Queries
7
Different statements
188.19 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.75 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.42 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy milf cock"
]
|
||||||||||||||||||||||||||||||
| 3 | 19.76 ms |
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 826172 814117 815692 817344 482564 458832 483592 583454 552582 563790 681059 690092 718806 589031 595619 631692 620496 618129 801375 803677 740347 756499 770633 812862 732406 734397 728908 428844 418161 526717 469484 540512 628622 732169 826114 822385 815933 818464 822575 674116 641322 793410 795059 800144 753338 811045 756513 733374 738571 762194 816929 816741 824125 828089 828333 536200 533335 699316 719748 653883 665258 702620 628295 630314 795894 724008 725209 725656 733086 744830 758499 718659 803323 408410 817837 817217 818423 517181 530445 538162 519711 563015 651314 676389 676549 687555 710575 678977 720318 555559 557101 604822 606671 616505 639061 604913 793616 810420 793670 805735 807389 725301 727007 727571 733120 733155 740024 749658 767928 733565 755991 762192 765895 744331 753729 740875 758765 759982 719176 448671 ] |
||||||||||||||||||||||||||||||
| 4 | 2.50 ms |
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 408410 418161 428844 448671 458832 469484 482564 483592 517181 519711 526717 530445 533335 536200 538162 540512 552582 555559 557101 563015 563790 583454 589031 595619 604822 604913 606671 616505 618129 620496 628295 628622 630314 631692 639061 641322 651314 653883 665258 674116 676389 676549 678977 681059 687555 690092 699316 702620 710575 718659 718806 719176 719748 720318 724008 725209 725301 725656 727007 727571 728908 732169 732406 733086 733120 733155 733374 733565 734397 738571 740024 740347 740875 744331 744830 749658 753338 753729 755991 756499 756513 758499 758765 759982 762192 762194 765895 767928 770633 793410 793616 793670 795059 795894 800144 801375 803323 803677 805735 807389 810420 811045 812862 814117 815692 815933 816741 816929 817217 817344 817837 818423 818464 822385 822575 824125 826114 826172 828089 828333 ] |
||||||||||||||||||||||||||||||
| 5 | 158.37 ms |
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 408410 418161 428844 448671 458832 469484 482564 483592 517181 519711 526717 530445 533335 536200 538162 540512 552582 555559 557101 563015 563790 583454 589031 595619 604822 604913 606671 616505 618129 620496 628295 628622 630314 631692 639061 641322 651314 653883 665258 674116 676389 676549 678977 681059 687555 690092 699316 702620 710575 718659 718806 719176 719748 720318 724008 725209 725301 725656 727007 727571 728908 732169 732406 733086 733120 733155 733374 733565 734397 738571 740024 740347 740875 744331 744830 749658 753338 753729 755991 756499 756513 758499 758765 759982 762192 762194 765895 767928 770633 793410 793616 793670 795059 795894 800144 801375 803323 803677 805735 807389 810420 811045 812862 814117 815692 815933 816741 816929 817217 817344 817837 818423 818464 822385 822575 824125 826114 826172 828089 828333 ] |
||||||||||||||||||||||||||||||
| 6 | 1.77 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy milf cock"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.62 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy milf 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.