Query Metrics
7
Database Queries
7
Different statements
119.25 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.80 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.43 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian girl masturbating"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.76 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 609574 755878 391980 398972 444999 429107 564486 486511 526102 513166 447385 549800 527675 547959 545702 553553 506098 689967 620676 795983 727037 725500 595088 522295 591088 444955 504626 508741 601893 619040 458995 459472 449822 463966 488733 489812 522763 476041 557989 616812 624268 445997 493396 568726 590398 594125 456556 519510 565863 546884 741799 597781 465162 495920 675589 449398 429861 546762 599421 521786 594262 450380 467233 450281 421827 624166 503506 567912 805139 563362 449208 588525 499764 522280 518870 528005 626576 444309 591432 526727 507669 571033 599644 513480 598161 598870 ] |
||||||||||||||||||||||||||||||
| 4 | 3.08 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 391980 398972 421827 429107 429861 444309 444955 444999 445997 447385 449208 449398 449822 450281 450380 456556 458995 459472 463966 465162 467233 476041 486511 488733 489812 493396 495920 499764 503506 504626 506098 507669 508741 513166 513480 518870 519510 521786 522280 522295 522763 526102 526727 527675 528005 545702 546762 546884 547959 549800 553553 557989 563362 564486 565863 567912 568726 571033 588525 590398 591088 591432 594125 594262 595088 597781 598161 598870 599421 599644 601893 609574 616812 619040 620676 624166 624268 626576 675589 689967 725500 727037 741799 755878 795983 805139 ] |
||||||||||||||||||||||||||||||
| 5 | 93.49 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 391980 398972 421827 429107 429861 444309 444955 444999 445997 447385 449208 449398 449822 450281 450380 456556 458995 459472 463966 465162 467233 476041 486511 488733 489812 493396 495920 499764 503506 504626 506098 507669 508741 513166 513480 518870 519510 521786 522280 522295 522763 526102 526727 527675 528005 545702 546762 546884 547959 549800 553553 557989 563362 564486 565863 567912 568726 571033 588525 590398 591088 591432 594125 594262 595088 597781 598161 598870 599421 599644 601893 609574 616812 619040 620676 624166 624268 626576 675589 689967 725500 727037 741799 755878 795983 805139 ] |
||||||||||||||||||||||||||||||
| 6 | 1.93 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск девушк masturbating"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.76 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск девушк masturbating"
]
|
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.