Query Metrics
7
Database Queries
7
Different statements
132.26 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.89 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.04 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom pussy hot"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.50 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 591369 596900 615979 618674 593441 593534 586503 591755 750701 760794 602063 409506 480372 472142 412367 421494 524560 484398 502730 519086 519093 520851 518304 609953 397364 481904 516991 571434 581873 650419 650188 629357 589023 624290 597787 809157 603713 401933 446173 480742 465840 448333 472829 510463 517564 509033 522759 522870 478049 454107 534845 564824 563787 625342 635783 807191 809930 486110 490182 504908 491473 512927 572886 447679 460669 607372 454709 474147 424527 516103 500716 508860 432751 519198 536584 645861 623251 487717 491804 494764 513303 565541 607374 453313 591135 614745 565783 ] |
||||||||||||||||||||||||||||||
| 4 | 3.30 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 397364 401933 409506 412367 421494 424527 432751 446173 447679 448333 453313 454107 454709 460669 465840 472142 472829 474147 478049 480372 480742 481904 484398 486110 487717 490182 491473 491804 494764 500716 502730 504908 508860 509033 510463 512927 513303 516103 516991 517564 518304 519086 519093 519198 520851 522759 522870 524560 534845 536584 563787 564824 565541 565783 571434 572886 581873 586503 589023 591135 591369 591755 593441 593534 596900 597787 602063 603713 607372 607374 609953 614745 615979 618674 623251 624290 625342 629357 635783 645861 650188 650419 750701 760794 807191 809157 809930 ] |
||||||||||||||||||||||||||||||
| 5 | 105.99 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 397364 401933 409506 412367 421494 424527 432751 446173 447679 448333 453313 454107 454709 460669 465840 472142 472829 474147 478049 480372 480742 481904 484398 486110 487717 490182 491473 491804 494764 500716 502730 504908 508860 509033 510463 512927 513303 516103 516991 517564 518304 519086 519093 519198 520851 522759 522870 524560 534845 536584 563787 564824 565541 565783 571434 572886 581873 586503 589023 591135 591369 591755 593441 593534 596900 597787 602063 603713 607372 607374 609953 614745 615979 618674 623251 624290 625342 629357 635783 645861 650188 650419 750701 760794 807191 809157 809930 ] |
||||||||||||||||||||||||||||||
| 6 | 1.97 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom pussy hot"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.57 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom pussy hot"
]
|
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.