Query Metrics
7
Database Queries
7
Different statements
213.56 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.54 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.55 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young teen gangbang"
]
|
||||||||||||||||||||||||||||||
| 3 | 17.46 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 745928 766625 720938 541076 645019 647333 650158 721846 628390 640797 666868 463122 530912 680127 566789 565245 628082 631196 565259 648543 400965 647969 666550 680112 716032 651188 671676 680126 704256 565260 581695 597266 602532 624179 628376 597253 597263 603168 628368 628392 595775 733909 733855 605338 614401 714436 716030 540334 680120 697025 530018 537206 518470 680207 634187 597963 550207 565254 584022 558131 679810 680185 702166 680118 627809 631965 628366 632588 632979 642751 624175 630526 632046 637080 733840 733870 642043 536227 575079 575803 637089 641413 522792 534028 680186 515568 820759 545604 649525 666535 668525 666878 704523 545393 633718 634482 637093 637422 628384 630524 627814 628398 631202 632298 637729 627808 633497 701310 598806 637074 390994 404368 576364 576052 574884 575461 575494 597230 641702 637026 ] |
||||||||||||||||||||||||||||||
| 4 | 4.05 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 390994 400965 404368 463122 515568 518470 522792 530018 530912 534028 536227 537206 540334 541076 545393 545604 550207 558131 565245 565254 565259 565260 566789 574884 575079 575461 575494 575803 576052 576364 581695 584022 595775 597230 597253 597263 597266 597963 598806 602532 603168 605338 614401 624175 624179 627808 627809 627814 628082 628366 628368 628376 628384 628390 628392 628398 630524 630526 631196 631202 631965 632046 632298 632588 632979 633497 633718 634187 634482 637026 637074 637080 637089 637093 637422 637729 640797 641413 641702 642043 642751 645019 647333 647969 648543 649525 650158 651188 666535 666550 666868 666878 668525 671676 679810 680112 680118 680120 680126 680127 680185 680186 680207 697025 701310 702166 704256 704523 714436 716030 716032 720938 721846 733840 733855 733870 733909 745928 766625 820759 ] |
||||||||||||||||||||||||||||||
| 5 | 185.69 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 390994 400965 404368 463122 515568 518470 522792 530018 530912 534028 536227 537206 540334 541076 545393 545604 550207 558131 565245 565254 565259 565260 566789 574884 575079 575461 575494 575803 576052 576364 581695 584022 595775 597230 597253 597263 597266 597963 598806 602532 603168 605338 614401 624175 624179 627808 627809 627814 628082 628366 628368 628376 628384 628390 628392 628398 630524 630526 631196 631202 631965 632046 632298 632588 632979 633497 633718 634187 634482 637026 637074 637080 637089 637093 637422 637729 640797 641413 641702 642043 642751 645019 647333 647969 648543 649525 650158 651188 666535 666550 666868 666878 668525 671676 679810 680112 680118 680120 680126 680127 680185 680186 680207 697025 701310 702166 704256 704523 714436 716030 716032 720938 721846 733840 733855 733870 733909 745928 766625 820759 ] |
||||||||||||||||||||||||||||||
| 6 | 1.73 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young teen gangbang"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.56 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young teen gangbang"
]
|
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.