Query Metrics
7
Database Queries
7
Different statements
200.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.35 ms (83.97%) |
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 145502 386524 400852 412362 422340 428883 429424 433703 437314 443563 443726 443792 446629 447333 447337 450641 452095 454262 454423 455281 456612 457163 461016 465312 466063 466180 466272 468641 470019 472003 473506 476339 476343 479080 479144 480377 481925 482353 482357 482803 483001 484470 484484 484562 484739 484775 485272 487321 487509 492069 496552 500725 506803 508701 512261 514748 517010 517015 517240 517874 519143 519929 519936 520151 520878 521135 523260 523508 524296 526729 526735 526894 529313 531064 532079 533519 534250 536655 541642 542969 543088 546058 547824 550662 552029 552306 555179 555182 555893 557499 560193 561468 562985 563146 563166 563444 563884 564173 564256 565578 565659 565679 565737 570169 572653 576649 580913 582137 583696 591632 603424 609746 611375 617191 617322 623615 623616 630537 667647 808060 ] |
||||||||||||||||||||||||||||||
|
20.78 ms (10.37%) |
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 523260 563884 552306 623615 492069 546058 565679 506803 386524 609746 555893 541642 552029 560193 582137 611375 623616 617191 630537 555179 564256 555182 521135 517015 443563 433703 482803 480377 482357 454423 455281 456612 468641 487509 523508 534250 520151 496552 531064 532079 484775 542969 561468 562985 563444 565578 557499 563146 564173 570169 572653 543088 547824 565737 563166 576649 583696 617322 591632 808060 603424 145502 400852 428883 437314 452095 466180 470019 482353 412362 454262 472003 479080 479144 429424 450641 476339 447337 481925 443726 443792 447333 465312 466063 466272 473506 514748 519929 526735 512261 517240 517874 519143 487321 484484 484562 500725 517010 519936 550662 422340 484470 446629 457163 461016 476343 484739 485272 524296 526894 533519 508701 526729 529313 536655 520878 483001 580913 565659 667647 ] |
||||||||||||||||||||||||||||||
|
3.82 ms (1.90%) |
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 145502 386524 400852 412362 422340 428883 429424 433703 437314 443563 443726 443792 446629 447333 447337 450641 452095 454262 454423 455281 456612 457163 461016 465312 466063 466180 466272 468641 470019 472003 473506 476339 476343 479080 479144 480377 481925 482353 482357 482803 483001 484470 484484 484562 484739 484775 485272 487321 487509 492069 496552 500725 506803 508701 512261 514748 517010 517015 517240 517874 519143 519929 519936 520151 520878 521135 523260 523508 524296 526729 526735 526894 529313 531064 532079 533519 534250 536655 541642 542969 543088 546058 547824 550662 552029 552306 555179 555182 555893 557499 560193 561468 562985 563146 563166 563444 563884 564173 564256 565578 565659 565679 565737 570169 572653 576649 580913 582137 583696 591632 603424 609746 611375 617191 617322 623615 623616 630537 667647 808060 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спящ young"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sleeping young"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"спящ young"
]
|
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.