Query Metrics
7
Database Queries
7
Different statements
148.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.38 ms (82.27%) |
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 345974 373950 391523 394187 396281 396361 399828 405700 408316 412534 414635 419073 420401 420619 425473 431366 432779 444135 447489 447567 448554 451710 452110 452171 453032 456327 458429 460705 461346 461903 464682 470161 470333 473969 475989 479470 484859 489524 490008 490019 490111 492271 504227 504461 504690 506850 509937 510658 511751 511762 512255 512273 513675 513824 514841 515125 515224 516822 516943 517024 519570 521907 528784 529057 529081 529282 538379 545188 545737 547902 548730 550935 552506 554356 557954 559181 561849 561852 566264 566548 569070 571211 573102 573635 574540 574552 574607 574870 574913 575421 575460 575479 575798 575811 576033 576367 578368 578384 590906 599800 604544 628394 659318 664624 715221 718160 718661 722875 722900 728323 730217 732068 739652 760120 766772 790223 806321 820971 822699 825299 ] |
||||||||||||||||||||||||||||||
|
17.10 ms (11.50%) |
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 519570 506850 547902 573635 574552 739652 715221 432779 396281 447567 456327 470333 460705 479470 510658 490008 490019 492271 512255 504690 513675 484859 490111 504461 373950 790223 517024 394187 820971 451710 575811 578368 545737 576033 548730 554356 718160 718661 552506 574870 728323 730217 391523 444135 511751 528784 489524 511762 452110 722875 722900 732068 475989 399828 405700 513824 504227 453032 509937 529081 561852 561849 566264 575798 578384 545188 557954 571211 574540 574607 574913 575421 575460 576367 412534 414635 464682 420619 448554 512273 516943 516822 664624 529057 659318 550935 599800 760120 408316 538379 419073 425473 822699 825299 458429 461346 461903 575479 569070 628394 473969 452171 470161 447489 515224 515125 521907 396361 420401 573102 566548 604544 766772 806321 431366 529282 345974 559181 590906 514841 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.75%) |
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 345974 373950 391523 394187 396281 396361 399828 405700 408316 412534 414635 419073 420401 420619 425473 431366 432779 444135 447489 447567 448554 451710 452110 452171 453032 456327 458429 460705 461346 461903 464682 470161 470333 473969 475989 479470 484859 489524 490008 490019 490111 492271 504227 504461 504690 506850 509937 510658 511751 511762 512255 512273 513675 513824 514841 515125 515224 516822 516943 517024 519570 521907 528784 529057 529081 529282 538379 545188 545737 547902 548730 550935 552506 554356 557954 559181 561849 561852 566264 566548 569070 571211 573102 573635 574540 574552 574607 574870 574913 575421 575460 575479 575798 575811 576033 576367 578368 578384 590906 599800 604544 628394 659318 664624 715221 718160 718661 722875 722900 728323 730217 732068 739652 760120 766772 790223 806321 820971 822699 825299 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex teens"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс teens"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс teens"
]
|
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.