Query Metrics
7
Database Queries
7
Different statements
171.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.58 ms (83.55%) |
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 142253 188064 191265 233029 252068 387782 388155 391705 392076 397210 397910 403426 404602 416982 428456 428854 430556 431117 439785 443173 443691 444582 444840 453262 454455 455976 459215 464890 466268 467602 477097 477444 479425 482496 484571 484648 484870 485276 489275 492346 493428 502738 516090 517556 524940 532818 533268 534239 536306 539402 561589 562832 562997 563083 563092 573941 580017 591054 591281 612574 612955 614937 619070 627777 657776 663260 671356 675359 689945 689983 700611 709204 711650 714872 714908 718550 720100 720517 723597 725250 725365 725570 725588 728231 728381 728447 730163 731444 736575 737372 739962 744321 746553 747107 753732 759566 759936 761219 768290 778853 788142 789176 789181 789350 789366 789374 792523 792539 793489 794102 794403 795299 796208 801426 802074 803725 807475 814865 ] |
||||||||||||||||||||||||||||||
|
17.12 ms (9.96%) |
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 479425 485276 464890 671356 431117 502738 482496 814865 484571 591054 387782 517556 714908 484648 489275 573941 466268 477097 539402 802074 768290 801426 562997 430556 467602 524940 562832 439785 416982 779805 795299 675359 725588 746553 580017 663260 443691 792539 403426 516090 744321 391705 388155 689983 725365 794102 736575 718550 759566 536306 563092 428854 714872 789366 803725 725250 753732 761219 612955 789181 789374 731444 492346 404602 484870 723597 709204 720517 711650 789350 455976 730163 459215 728381 759936 563083 807475 532818 778853 728231 789176 443173 453262 534239 233029 561589 392076 591281 454455 689945 397210 397910 142253 619070 188064 739962 657776 614937 700611 792523 428456 533268 477444 720100 612574 788142 793489 796208 725213 747107 627777 794403 444840 493428 252068 728447 444582 725570 737372 191265 ] |
||||||||||||||||||||||||||||||
|
3.43 ms (2.00%) |
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 142253 188064 191265 233029 252068 387782 388155 391705 392076 397210 397910 403426 404602 416982 428456 428854 430556 431117 439785 443173 443691 444582 444840 453262 454455 455976 459215 464890 466268 467602 477097 477444 479425 482496 484571 484648 484870 485276 489275 492346 493428 502738 516090 517556 524940 532818 533268 534239 536306 539402 561589 562832 562997 563083 563092 573941 580017 591054 591281 612574 612955 614937 619070 627777 657776 663260 671356 675359 689945 689983 700611 709204 711650 714872 714908 718550 720100 720517 723597 725250 725365 725570 725588 728231 728381 728447 730163 731444 736575 737372 739962 744321 746553 747107 753732 759566 759936 761219 768290 778853 788142 789176 789181 789350 789366 789374 792523 792539 793489 794102 794403 795299 796208 801426 802074 803725 807475 814865 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boy and mother"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парен мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"парен мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.