Query Metrics
7
Database Queries
7
Different statements
146.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.51 ms (81.48%) |
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 181851 187775 340567 352187 390924 391327 400726 410694 414372 429069 429555 432997 434307 435794 437248 441120 444391 444915 447936 448464 448758 450670 450977 452373 458675 468975 470198 471128 471148 473437 473887 476514 477198 477366 477809 482383 482541 483738 485297 490501 501951 505242 510176 510324 511012 511365 511528 511534 511866 513569 514369 514408 515089 515452 516640 517710 519661 520492 520963 521110 521343 523131 523381 523568 523875 523975 524117 524306 524310 525399 525968 526292 526833 527574 527884 528000 528005 528009 529741 531822 531852 531856 533600 537141 537250 539470 541487 552343 554582 554742 556483 557975 559377 559796 560825 564984 567860 568802 569281 598388 598882 604105 605862 609136 615022 620086 625783 626089 629962 642004 696591 745083 777416 786444 793151 796333 796706 796716 806910 810772 ] |
||||||||||||||||||||||||||||||
|
17.67 ms (12.05%) |
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 564984 598388 448758 514369 510324 527884 559377 448464 452373 485297 450670 615022 437248 569281 525399 527574 429555 447936 515452 501951 568802 471128 517710 625783 523381 786444 806910 432997 470198 477198 477366 523975 533600 528009 554582 458675 524306 511012 187775 520492 526292 629962 523568 567860 513569 519661 400726 537250 557975 515089 521343 524117 626089 810772 777416 390924 521110 528000 468975 505242 510176 541487 473887 434307 524310 477809 528005 444915 511365 523131 554742 490501 556483 482541 520963 482383 560825 552343 476514 429069 523875 514408 414372 525968 609136 526833 511528 511534 450977 435794 444391 605862 620086 559796 539470 340567 598882 796706 473437 604105 352187 441120 391327 796716 410694 516640 529741 537141 696591 642004 511866 181851 531852 531822 531856 745083 471148 793151 796333 483738 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.96%) |
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 181851 187775 340567 352187 390924 391327 400726 410694 414372 429069 429555 432997 434307 435794 437248 441120 444391 444915 447936 448464 448758 450670 450977 452373 458675 468975 470198 471128 471148 473437 473887 476514 477198 477366 477809 482383 482541 483738 485297 490501 501951 505242 510176 510324 511012 511365 511528 511534 511866 513569 514369 514408 515089 515452 516640 517710 519661 520492 520963 521110 521343 523131 523381 523568 523875 523975 524117 524306 524310 525399 525968 526292 526833 527574 527884 528000 528005 528009 529741 531822 531852 531856 533600 537141 537250 539470 541487 552343 554582 554742 556483 557975 559377 559796 560825 564984 567860 568802 569281 598388 598882 604105 605862 609136 615022 620086 625783 626089 629962 642004 696591 745083 777416 786444 793151 796333 796706 796716 806910 810772 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"большая жопа и дилдо"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп дилд"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.87%) |
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.