Query Metrics
7
Database Queries
7
Different statements
162.91 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.38 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.87 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cute ass licking"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.73 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 473781 514768 487713 462977 512855 519084 518361 524157 714109 732061 629411 785423 423612 427086 468613 501650 521483 517388 521901 544686 482758 576021 549475 577837 599664 616758 731947 788315 479212 451095 505905 488600 615608 444367 524979 513324 525058 475202 537685 420654 507601 519487 525450 554646 591016 592479 732878 521715 423633 525935 571724 558088 576270 581683 598794 590959 604142 418494 523756 814072 537672 537670 452327 431448 673661 628363 528146 498054 560202 523167 568371 559095 603102 557236 642705 536766 591077 420559 501641 515545 560786 508430 538963 527975 526248 602268 651933 568450 ] |
||||||||||||||||||||||||||||||
| 4 | 2.97 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 418494 420559 420654 423612 423633 427086 431448 444367 451095 452327 462977 468613 473781 475202 479212 482758 487713 488600 498054 501641 501650 505905 507601 508430 512855 513324 514768 515545 517388 518361 519084 519487 521483 521715 521901 523167 523756 524157 524979 525058 525450 525935 526248 527975 528146 536766 537670 537672 537685 538963 544686 549475 554646 557236 558088 559095 560202 560786 568371 568450 571724 576021 576270 577837 581683 590959 591016 591077 592479 598794 599664 602268 603102 604142 615608 616758 628363 629411 642705 651933 673661 714109 731947 732061 732878 785423 788315 814072 ] |
||||||||||||||||||||||||||||||
| 5 | 138.63 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 418494 420559 420654 423612 423633 427086 431448 444367 451095 452327 462977 468613 473781 475202 479212 482758 487713 488600 498054 501641 501650 505905 507601 508430 512855 513324 514768 515545 517388 518361 519084 519487 521483 521715 521901 523167 523756 524157 524979 525058 525450 525935 526248 527975 528146 536766 537670 537672 537685 538963 544686 549475 554646 557236 558088 559095 560202 560786 568371 568450 571724 576021 576270 577837 581683 590959 591016 591077 592479 598794 599664 602268 603102 604142 615608 616758 628363 629411 642705 651933 673661 714109 731947 732061 732878 785423 788315 814072 ] |
||||||||||||||||||||||||||||||
| 6 | 1.69 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cute жоп лиза"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.65 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cute жоп лиза"
]
|
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.