Query Metrics
7
Database Queries
7
Different statements
136.59 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.29 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.74 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy in boyfriend"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.69 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 567346 573304 653876 606681 587952 590889 612439 639972 608775 611559 641901 477043 400237 437587 470130 442864 476800 404251 484032 488362 535009 525840 598592 402378 417064 435452 443991 816086 481157 524689 500482 490916 543810 658661 602492 586539 395622 396012 481162 492827 495631 527304 513039 522971 389066 430210 420411 814235 481674 492510 562858 582811 601063 809902 480726 438095 441191 446984 479011 487156 505018 448100 471626 546669 609199 626364 471639 428110 445672 523260 554905 598500 587192 526773 511770 424627 651933 565927 436178 425490 525651 612455 625359 439819 405287 513845 464328 ] |
||||||||||||||||||||||||||||||
| 4 | 3.13 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 389066 395622 396012 400237 402378 404251 405287 417064 420411 424627 425490 428110 430210 435452 436178 437587 438095 439819 441191 442864 443991 445672 446984 448100 464328 470130 471626 471639 476800 477043 479011 480726 481157 481162 481674 484032 487156 488362 490916 492510 492827 495631 500482 505018 511770 513039 513845 522971 523260 524689 525651 525840 526773 527304 535009 543810 546669 554905 562858 565927 567346 573304 582811 586539 587192 587952 590889 598500 598592 601063 602492 606681 608775 609199 611559 612439 612455 625359 626364 639972 641901 651933 653876 658661 809902 814235 816086 ] |
||||||||||||||||||||||||||||||
| 5 | 112.97 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 389066 395622 396012 400237 402378 404251 405287 417064 420411 424627 425490 428110 430210 435452 436178 437587 438095 439819 441191 442864 443991 445672 446984 448100 464328 470130 471626 471639 476800 477043 479011 480726 481157 481162 481674 484032 487156 488362 490916 492510 492827 495631 500482 505018 511770 513039 513845 522971 523260 524689 525651 525840 526773 527304 535009 543810 546669 554905 562858 565927 567346 573304 582811 586539 587192 587952 590889 598500 598592 601063 602492 606681 608775 609199 611559 612439 612455 625359 626364 639972 641901 651933 653876 658661 809902 814235 816086 ] |
||||||||||||||||||||||||||||||
| 6 | 1.62 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy boyfriend"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.15 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy boyfriend"
]
|
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.