Query Metrics
7
Database Queries
7
Different statements
148.43 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.57 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.98 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"riding teen dildo"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.33 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 814411 813899 453820 482731 500910 528315 674177 662389 683183 713375 641837 803040 787515 813275 769143 745100 747313 770269 765896 720077 806583 497690 478055 545428 637537 477757 524687 630297 623205 453409 522043 547241 547490 386468 437874 662603 680928 695199 604824 747328 765628 770250 752653 748521 770410 795396 498297 696582 585826 13075 591021 761231 387014 446709 522307 504173 630533 421678 507288 542692 682521 628315 416663 439029 513485 519240 587235 565254 646450 437548 454931 704205 501382 495397 422044 524676 523357 514236 514248 545384 652289 653302 ] |
||||||||||||||||||||||||||||||
| 4 | 2.54 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 13075 386468 387014 416663 421678 422044 437548 437874 439029 446709 453409 453820 454931 477757 478055 482731 495397 497690 498297 500910 501382 504173 507288 513485 514236 514248 519240 522043 522307 523357 524676 524687 528315 542692 545384 545428 547241 547490 565254 585826 587235 591021 604824 623205 628315 630297 630533 637537 641837 646450 652289 653302 662389 662603 674177 680928 682521 683183 695199 696582 704205 713375 720077 745100 747313 747328 748521 752653 761231 765628 765896 769143 770250 770269 770410 787515 795396 803040 806583 813275 813899 814411 ] |
||||||||||||||||||||||||||||||
| 5 | 123.13 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 13075 386468 387014 416663 421678 422044 437548 437874 439029 446709 453409 453820 454931 477757 478055 482731 495397 497690 498297 500910 501382 504173 507288 513485 514236 514248 519240 522043 522307 523357 524676 524687 528315 542692 545384 545428 547241 547490 565254 585826 587235 591021 604824 623205 628315 630297 630533 637537 641837 646450 652289 653302 662389 662603 674177 680928 682521 683183 695199 696582 704205 713375 720077 745100 747313 747328 748521 752653 761231 765628 765896 769143 770250 770269 770410 787515 795396 803040 806583 813275 813899 814411 ] |
||||||||||||||||||||||||||||||
| 6 | 1.54 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"riding teen дилд"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.34 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"riding teen дилд"
]
|
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.