Query Metrics
7
Database Queries
7
Different statements
214.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
188.05 ms (87.71%) |
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 187723 233025 233049 233446 233610 233647 358264 365908 365954 387422 391483 391580 392037 392673 394190 397908 398956 401003 402547 410193 411323 411399 411417 414319 415827 419998 421828 423960 424072 424114 424146 426741 426935 427004 428039 431594 437121 438025 443690 443715 443938 444245 446634 451455 451487 452958 454279 457053 460551 460581 461814 461950 462347 466040 467847 469912 470493 470683 470973 472605 473949 473954 475219 475557 475589 475901 476655 479357 479409 480012 481283 482045 483767 483855 484185 485595 490118 490936 491098 491125 491903 494573 495251 500217 503442 503450 507547 513203 513681 516175 516668 521480 539487 546011 552590 556298 556846 563188 576121 590533 597089 601257 601261 601883 718746 721489 741246 741713 751637 762500 772660 777843 781766 782249 782272 782276 785490 801290 804477 805248 ] |
||||||||||||||||||||||||||||||
|
16.58 ms (7.73%) |
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 415827 421828 503450 467847 387422 454279 451455 391580 460581 398956 718746 446634 491125 233647 438025 444245 443938 472605 500217 476655 556298 452958 410193 462347 479357 480012 423960 431594 457053 461950 469912 424072 426741 437121 475219 475557 521480 483767 490118 483855 484185 482045 475901 597089 233049 781766 782249 782272 782276 233025 451487 590533 801290 805248 741246 233610 233446 365954 516668 539487 187723 401003 419998 397908 546011 741713 443715 411417 411323 490936 473949 473954 470973 513203 513681 365908 392673 394190 424114 470683 475589 470493 552590 762500 391483 414319 424146 411399 466040 428039 461814 491903 503442 563188 426935 427004 479409 392037 460551 494573 495251 507547 485595 516175 358264 443690 576121 721489 601257 601261 601883 777843 772660 751637 785490 804477 402547 491098 556846 481283 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.42%) |
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 187723 233025 233049 233446 233610 233647 358264 365908 365954 387422 391483 391580 392037 392673 394190 397908 398956 401003 402547 410193 411323 411399 411417 414319 415827 419998 421828 423960 424072 424114 424146 426741 426935 427004 428039 431594 437121 438025 443690 443715 443938 444245 446634 451455 451487 452958 454279 457053 460551 460581 461814 461950 462347 466040 467847 469912 470493 470683 470973 472605 473949 473954 475219 475557 475589 475901 476655 479357 479409 480012 481283 482045 483767 483855 484185 485595 490118 490936 491098 491125 491903 494573 495251 500217 503442 503450 507547 513203 513681 516175 516668 521480 539487 546011 552590 556298 556846 563188 576121 590533 597089 601257 601261 601883 718746 721489 741246 741713 751637 762500 772660 777843 781766 782249 782272 782276 785490 801290 804477 805248 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"россия мамки"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.65%) |
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.