Query Metrics
7
Database Queries
7
Different statements
145.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.73 ms (82.45%) |
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 3417 7051 68246 80370 172514 185753 229361 233692 325253 337061 382545 384025 384514 384801 388127 388464 388546 388888 389146 389314 390888 391567 391684 395381 395643 396087 396801 397366 397388 398405 398934 400941 401139 402239 402729 402929 403257 403870 405114 405556 405749 406362 406981 407856 408798 410254 411125 414736 414924 422434 422487 426090 431603 431724 431735 433981 441530 441804 442164 442997 445002 447335 447940 449144 453689 453895 456918 456945 457352 457897 459843 460397 461463 463133 469654 470101 471402 475048 475237 476278 477258 479243 488070 488950 489881 496399 499636 505048 507018 509020 510634 512302 512320 514196 522535 523699 524415 526483 526651 547306 552161 565430 566122 570028 573953 591677 595405 597516 654722 656789 657352 659554 725914 742138 780806 783155 784852 787195 787351 801141 ] |
||||||||||||||||||||||||||||||
|
15.07 ms (10.38%) |
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 591677 384025 382545 433981 461463 422487 431735 442164 401139 422434 445002 414924 469654 509020 510634 172514 402929 456945 526483 479243 488070 547306 657352 654722 595405 780806 784852 783155 801141 742138 384514 403870 411125 431724 233692 389146 397388 389314 337061 406362 414736 514196 229361 441804 489881 449144 570028 552161 391567 396801 426090 403257 456918 524415 400941 407856 384801 390888 475237 397366 398934 453689 499636 523699 325253 68246 7051 3417 388464 388888 388127 408798 431603 453895 457897 488950 459843 496399 470101 725914 787351 441530 475048 405749 447335 185753 447940 388546 402239 457352 460397 526651 507018 512302 522535 405556 659554 573953 406981 512320 787195 402729 80370 395381 391684 565430 398405 477258 566122 656789 597516 396087 505048 410254 463133 405114 442997 471402 476278 395643 ] |
||||||||||||||||||||||||||||||
|
3.24 ms (2.23%) |
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 3417 7051 68246 80370 172514 185753 229361 233692 325253 337061 382545 384025 384514 384801 388127 388464 388546 388888 389146 389314 390888 391567 391684 395381 395643 396087 396801 397366 397388 398405 398934 400941 401139 402239 402729 402929 403257 403870 405114 405556 405749 406362 406981 407856 408798 410254 411125 414736 414924 422434 422487 426090 431603 431724 431735 433981 441530 441804 442164 442997 445002 447335 447940 449144 453689 453895 456918 456945 457352 457897 459843 460397 461463 463133 469654 470101 471402 475048 475237 476278 477258 479243 488070 488950 489881 496399 499636 505048 507018 509020 510634 512302 512320 514196 522535 523699 524415 526483 526651 547306 552161 565430 566122 570028 573953 591677 595405 597516 654722 656789 657352 659554 725914 742138 780806 783155 784852 787195 787351 801141 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"девушка парня"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк парен"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.17%) |
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.