Query Metrics
7
Database Queries
7
Different statements
148.76 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.86 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.29 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina fuck жмж"
]
|
||||||||||||||||||||||||||||||
| 3 | 13.71 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 537661 406698 545086 430697 521581 390057 486963 568324 544668 815268 492534 512889 534312 575193 599200 724305 472941 573234 586497 601669 425523 480719 503967 606748 414172 467395 502043 532129 557259 420541 629950 472505 611986 526443 471380 553190 532357 477686 516309 529213 407252 386874 418828 473915 449372 487518 431365 478807 452518 520311 578326 811826 437868 527416 535344 608376 448839 510286 507609 433494 560205 531920 433179 561576 464384 461595 479196 430018 543604 424328 508523 424364 458010 536695 622184 590667 699610 515119 519933 586484 565050 452097 610606 493958 464266 438896 428372 ] |
||||||||||||||||||||||||||||||
| 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 386874 390057 406698 407252 414172 418828 420541 424328 424364 425523 428372 430018 430697 431365 433179 433494 437868 438896 448839 449372 452097 452518 458010 461595 464266 464384 467395 471380 472505 472941 473915 477686 478807 479196 480719 486963 487518 492534 493958 502043 503967 507609 508523 510286 512889 515119 516309 519933 520311 521581 526443 527416 529213 531920 532129 532357 534312 535344 536695 537661 543604 544668 545086 553190 557259 560205 561576 565050 568324 573234 575193 578326 586484 586497 590667 599200 601669 606748 608376 610606 611986 622184 629950 699610 724305 811826 815268 ] |
||||||||||||||||||||||||||||||
| 5 | 125.32 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 386874 390057 406698 407252 414172 418828 420541 424328 424364 425523 428372 430018 430697 431365 433179 433494 437868 438896 448839 449372 452097 452518 458010 461595 464266 464384 467395 471380 472505 472941 473915 477686 478807 479196 480719 486963 487518 492534 493958 502043 503967 507609 508523 510286 512889 515119 516309 519933 520311 521581 526443 527416 529213 531920 532129 532357 534312 535344 536695 537661 543604 544668 545086 553190 557259 560205 561576 565050 568324 573234 575193 578326 586484 586497 590667 599200 601669 606748 608376 610606 611986 622184 629950 699610 724305 811826 815268 ] |
||||||||||||||||||||||||||||||
| 6 | 1.56 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская секс жмж секс втро"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.40 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская секс жмж секс втро"
]
|
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.