Query Metrics
7
Database Queries
7
Different statements
379.63 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.66 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.89 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf boy sleep"
]
|
||||||||||||||||||||||||||||||
| 3 | 18.28 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 614603 421287 492267 550615 428022 425975 430210 430190 482243 455685 486870 504162 518108 521027 552319 564647 562858 575241 582789 675458 552268 563014 581098 606567 789665 609803 466081 424437 460734 476908 430314 383045 520021 563865 469019 462949 512927 788861 467966 557537 560230 552306 580270 584739 490944 415710 439819 413934 446313 464549 464386 470018 474418 583146 717167 532129 515122 533966 532039 561298 619107 643364 609225 469424 469476 420635 508236 529485 726526 614745 560511 446864 453716 531920 516308 466213 466103 524276 464438 544495 590135 501259 526118 630993 464442 559950 512952 536910 490204 541611 ] |
||||||||||||||||||||||||||||||
| 4 | 2.61 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 383045 413934 415710 420635 421287 424437 425975 428022 430190 430210 430314 439819 446313 446864 453716 455685 460734 462949 464386 464438 464442 464549 466081 466103 466213 467966 469019 469424 469476 470018 474418 476908 482243 486870 490204 490944 492267 501259 504162 508236 512927 512952 515122 516308 518108 520021 521027 524276 526118 529485 531920 532039 532129 533966 536910 541611 544495 550615 552268 552306 552319 557537 559950 560230 560511 561298 562858 563014 563865 564647 575241 580270 581098 582789 583146 584739 590135 606567 609225 609803 614603 614745 619107 630993 643364 675458 717167 726526 788861 789665 ] |
||||||||||||||||||||||||||||||
| 5 | 352.09 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 383045 413934 415710 420635 421287 424437 425975 428022 430190 430210 430314 439819 446313 446864 453716 455685 460734 462949 464386 464438 464442 464549 466081 466103 466213 467966 469019 469424 469476 470018 474418 476908 482243 486870 490204 490944 492267 501259 504162 508236 512927 512952 515122 516308 518108 520021 521027 524276 526118 529485 531920 532039 532129 533966 536910 541611 544495 550615 552268 552306 552319 557537 559950 560230 560511 561298 562858 563014 563865 564647 575241 580270 581098 582789 583146 584739 590135 606567 609225 609803 614603 614745 619107 630993 643364 675458 717167 726526 788861 789665 ] |
||||||||||||||||||||||||||||||
| 6 | 1.73 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf парен спящ"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.36 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf парен спящ"
]
|
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.