Query Metrics
7
Database Queries
7
Different statements
200.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.85 ms (87.73%) |
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 9938 191450 283983 327085 382173 383923 384200 385274 386555 386727 391096 394754 396438 397145 397942 401213 403346 404608 406334 407382 410356 419055 419661 419951 420231 420808 422529 422558 423063 423080 423398 429543 431603 431607 431664 433299 435948 445233 445374 446478 446481 448536 456176 457264 457759 459263 459819 460939 460959 462306 471178 471355 473768 477403 488816 491512 499036 510168 511266 512033 512216 514627 515279 516452 521122 529436 533121 533691 535985 539095 540130 540201 540213 542642 546038 546493 550138 550732 550739 550776 551888 551949 552028 552897 552899 554340 554764 557237 558426 558431 559855 559873 559874 559875 559882 562051 569726 572738 577064 577251 583213 583280 585381 590949 591278 593431 598515 600806 608009 618483 619433 637737 640685 644912 645559 647074 651667 748670 817179 827987 ] |
||||||||||||||||||||||||||||||
|
14.86 ms (7.41%) |
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 546038 550138 550776 551949 552028 552897 552899 554764 558426 558431 559855 559873 572738 583280 590949 600806 591278 619433 593431 598515 637737 585381 618483 608009 640685 394754 423080 431664 435948 459263 401213 422529 445233 456176 462306 420808 429543 471355 473768 384200 420231 423398 457264 457759 459819 422558 446481 529436 488816 491512 515279 499036 512216 521122 382173 817179 827987 748670 386555 386727 383923 385274 191450 283983 327085 9938 391096 396438 397145 397942 403346 406334 404608 419055 431607 407382 410356 433299 419951 423063 431603 419661 445374 644912 448536 460939 477403 446478 460959 471178 535985 539095 533691 540201 540213 510168 533121 540130 511266 512033 514627 516452 542642 546493 550732 550739 557237 559874 559875 562051 583213 559882 577064 551888 554340 569726 577251 645559 647074 651667 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.47%) |
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 9938 191450 283983 327085 382173 383923 384200 385274 386555 386727 391096 394754 396438 397145 397942 401213 403346 404608 406334 407382 410356 419055 419661 419951 420231 420808 422529 422558 423063 423080 423398 429543 431603 431607 431664 433299 435948 445233 445374 446478 446481 448536 456176 457264 457759 459263 459819 460939 460959 462306 471178 471355 473768 477403 488816 491512 499036 510168 511266 512033 512216 514627 515279 516452 521122 529436 533121 533691 535985 539095 540130 540201 540213 542642 546038 546493 550138 550732 550739 550776 551888 551949 552028 552897 552899 554340 554764 557237 558426 558431 559855 559873 559874 559875 559882 562051 569726 572738 577064 577251 583213 583280 585381 590949 591278 593431 598515 600806 608009 618483 619433 637737 640685 644912 645559 647074 651667 748670 817179 827987 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian 2023"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.69%) |
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.