Query Metrics
7
Database Queries
7
Different statements
328.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
297.55 ms (90.69%) |
1 |
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 389014 389504 390790 391186 396044 396333 396593 396617 397993 398469 401153 402016 402393 403067 406684 410702 411552 411902 413112 413967 414016 416180 416187 419052 420253 420417 421426 422180 423060 424534 426490 428044 429519 429585 430273 430737 435106 437227 438911 443469 443475 445046 445808 446219 446630 446868 447418 447581 447912 450692 451293 452045 452294 452532 453007 454046 454195 455419 456055 456209 456566 457843 458113 458431 458607 459036 459340 459566 459978 460182 460534 460855 461063 461797 461969 462086 463488 464903 465166 466301 466695 466828 466948 467021 467639 467761 469079 469187 469196 469652 470128 470643 472560 473865 475501 475725 476202 476365 479065 479252 479438 479822 480255 481753 482260 483042 484003 485312 485620 485795 487972 488195 489446 490710 491588 496231 498111 500680 505057 506483 ] |
||||||||||||||||||||||||||||||
|
20.35 ms (6.20%) |
1 |
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 389014 389504 391186 390790 396044 396617 396333 396593 397993 398469 401153 402016 402393 403067 406684 411552 416180 414016 420253 421426 423060 426490 428044 430737 443469 443475 413967 420417 429519 445046 413112 419052 422180 430273 435106 410702 411902 416187 424534 429585 437227 438911 445808 451293 452294 452532 453007 456566 458607 459340 459566 460855 462086 466301 466695 466948 469187 469652 473865 475501 475725 476202 479438 479822 480255 482260 487972 446219 447418 454046 461797 461969 465166 467761 470128 476365 479252 481753 483042 484003 485312 489446 491588 446630 446868 447581 447912 450692 452045 454195 455419 456055 456209 457843 458113 458431 459036 460182 467021 472560 485620 485795 488195 490710 498111 500680 506483 496231 505057 459978 460534 461063 463488 464903 466828 467639 469079 469196 470643 479065 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (0.97%) |
1 |
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 389014 389504 390790 391186 396044 396333 396593 396617 397993 398469 401153 402016 402393 403067 406684 410702 411552 411902 413112 413967 414016 416180 416187 419052 420253 420417 421426 422180 423060 424534 426490 428044 429519 429585 430273 430737 435106 437227 438911 443469 443475 445046 445808 446219 446630 446868 447418 447581 447912 450692 451293 452045 452294 452532 453007 454046 454195 455419 456055 456209 456566 457843 458113 458431 458607 459036 459340 459566 459978 460182 460534 460855 461063 461797 461969 462086 463488 464903 465166 466301 466695 466828 466948 467021 467639 467761 469079 469187 469196 469652 470128 470643 472560 473865 475501 475725 476202 476365 479065 479252 479438 479822 480255 481753 482260 483042 484003 485312 485620 485795 487972 488195 489446 490710 491588 496231 498111 500680 505057 506483 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.60%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"порно ротика"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"порн ротик"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.51%) |
1 |
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.