Query Metrics
7
Database Queries
7
Different statements
223.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
195.89 ms (87.75%) |
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 7161 91344 95673 118284 118479 154826 229105 233025 293499 381964 382165 382430 383924 384108 385225 386345 387218 387937 392100 393326 396071 398741 401479 401532 406817 408692 414292 414337 415292 417348 424581 425707 428568 432683 441095 442117 443087 443097 445397 445470 445745 447920 448873 449070 451266 451609 451758 452746 453585 453788 453822 454270 460533 461924 466991 467155 470412 471312 475502 475504 477052 478442 478512 485338 488713 493477 494999 495737 501611 506149 506268 507661 507696 507772 508935 510812 515969 520713 524791 534567 534627 544819 555023 556872 556906 557336 559194 559910 565256 565539 566786 580773 583943 592259 593292 622329 628087 628384 632046 632588 634561 639379 646884 666535 666550 666875 666878 688105 694178 720306 725382 726292 736022 743893 760381 760392 789223 790392 790876 827737 ] |
||||||||||||||||||||||||||||||
|
17.06 ms (7.64%) |
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 392100 385225 382430 406817 293499 485338 453822 466991 556906 453585 415292 449070 424581 506268 566786 398741 95673 414292 401479 694178 386345 381964 583943 442117 443097 451758 495737 559910 556872 445397 471312 460533 488713 593292 534567 666550 445745 501611 118479 118284 393326 827737 233025 417348 557336 384108 408692 646884 632588 632046 467155 387218 428568 441095 478512 524791 510812 639379 451609 506149 494999 622329 396071 520713 666535 666875 666878 628384 493477 387937 425707 507696 544819 790392 7161 91344 432683 452746 559194 443087 507661 592259 461924 451266 454270 565256 580773 628087 229105 382165 453788 790876 447920 534627 634561 414337 448873 470412 565539 555023 515969 154826 401532 477052 475502 478442 507772 508935 475504 688105 720306 726292 736022 760381 789223 760392 743893 725382 383924 445470 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (1.42%) |
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 7161 91344 95673 118284 118479 154826 229105 233025 293499 381964 382165 382430 383924 384108 385225 386345 387218 387937 392100 393326 396071 398741 401479 401532 406817 408692 414292 414337 415292 417348 424581 425707 428568 432683 441095 442117 443087 443097 445397 445470 445745 447920 448873 449070 451266 451609 451758 452746 453585 453788 453822 454270 460533 461924 466991 467155 470412 471312 475502 475504 477052 478442 478512 485338 488713 493477 494999 495737 501611 506149 506268 507661 507696 507772 508935 510812 515969 520713 524791 534567 534627 544819 555023 556872 556906 557336 559194 559910 565256 565539 566786 580773 583943 592259 593292 622329 628087 628384 632046 632588 634561 639379 646884 666535 666550 666875 666878 688105 694178 720306 725382 726292 736022 743893 760381 760392 789223 790392 790876 827737 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"фистинг мужика порно"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фистинг мужчин порн"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.72%) |
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.