Query Metrics
7
Database Queries
7
Different statements
179.42 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.01 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.86 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam cumshot"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.66 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 644098 810772 759135 724637 731442 760952 602104 602698 605589 613852 802734 432479 434241 467914 481279 420615 423980 433904 448300 471598 446989 481727 481401 526288 496666 498346 514118 525377 516117 492564 500839 428701 445314 491121 451779 458984 500497 528661 534616 573457 575550 580329 567608 568655 657780 588200 605474 587377 623376 459961 433531 471765 486909 487407 508596 455351 517575 499178 509678 523823 495140 539955 551579 555968 668668 604097 432510 454397 449462 454456 525451 499026 427261 453683 508425 567060 561296 584013 599540 587229 452965 527295 514129 574095 545647 440990 507512 523828 605151 480326 ] |
||||||||||||||||||||||||||||||
| 4 | 2.90 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 420615 423980 427261 428701 432479 432510 433531 433904 434241 440990 445314 446989 448300 449462 451779 452965 453683 454397 454456 455351 458984 459961 467914 471598 471765 480326 481279 481401 481727 486909 487407 491121 492564 495140 496666 498346 499026 499178 500497 500839 507512 508425 508596 509678 514118 514129 516117 517575 523823 523828 525377 525451 526288 527295 528661 534616 539955 545647 551579 555968 561296 567060 567608 568655 573457 574095 575550 580329 584013 587229 587377 588200 599540 602104 602698 604097 605151 605474 605589 613852 623376 644098 657780 668668 724637 731442 759135 760952 802734 810772 ] |
||||||||||||||||||||||||||||||
| 5 | 154.38 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 420615 423980 427261 428701 432479 432510 433531 433904 434241 440990 445314 446989 448300 449462 451779 452965 453683 454397 454456 455351 458984 459961 467914 471598 471765 480326 481279 481401 481727 486909 487407 491121 492564 495140 496666 498346 499026 499178 500497 500839 507512 508425 508596 509678 514118 514129 516117 517575 523823 523828 525377 525451 526288 527295 528661 534616 539955 545647 551579 555968 561296 567060 567608 568655 573457 574095 575550 580329 584013 587229 587377 588200 599540 602104 602698 604097 605151 605474 605589 613852 623376 644098 657780 668668 724637 731442 759135 760952 802734 810772 ] |
||||||||||||||||||||||||||||||
| 6 | 1.85 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер cumshot"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.76 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер cumshot"
]
|
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.