Query Metrics
7
Database Queries
7
Different statements
155.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.03 ms (83.17%) |
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 391448 392801 393845 395598 396086 396154 396673 398477 400167 401468 404032 404399 404730 405324 413495 415257 419151 419807 427702 427776 429473 433940 438349 438838 442508 443229 444959 445082 445841 446239 446328 446673 446727 446967 447441 447511 447638 447675 447738 447910 449092 450330 451145 451831 453934 454461 454591 454645 454875 456263 456382 456507 456941 456982 457565 459261 459404 459711 459826 460453 461760 462696 462911 463379 464601 465093 466033 467373 467804 469102 469112 469410 469493 470118 471002 471582 472222 472263 472295 472322 472525 472530 473239 474682 475025 475061 475225 475256 475467 475720 476567 478140 478409 478655 479271 480395 482723 483389 483578 483579 487297 492183 492470 499871 502302 506876 510608 510809 511338 515263 517915 524204 524783 529333 542651 558359 563839 586584 680923 ] |
||||||||||||||||||||||||||||||
|
17.35 ms (11.18%) |
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 482723 451831 454875 456982 469102 470118 472222 472263 492183 446673 447738 449092 453934 454645 456507 459711 459826 464601 466033 475720 492470 445841 446328 446967 450330 451145 454591 459261 462696 462911 465093 472295 472525 472530 478655 483578 487297 502302 524783 499871 511338 515263 517915 524204 527201 510608 529333 506876 510809 461760 469493 472322 474682 475061 475256 475467 483389 483579 563839 542651 680923 558359 586584 391448 396154 404399 427776 438349 446239 446727 447675 456382 456941 463379 473239 475025 475225 478409 393845 396673 398477 400167 401468 405324 419807 442508 443229 444959 447511 447910 459404 469112 471002 478140 479271 392801 395598 415257 419151 429473 457565 467373 467804 469410 471582 476567 480395 396086 404032 404730 413495 427702 433940 438838 445082 447441 447638 454461 456263 460453 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.64%) |
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 391448 392801 393845 395598 396086 396154 396673 398477 400167 401468 404032 404399 404730 405324 413495 415257 419151 419807 427702 427776 429473 433940 438349 438838 442508 443229 444959 445082 445841 446239 446328 446673 446727 446967 447441 447511 447638 447675 447738 447910 449092 450330 451145 451831 453934 454461 454591 454645 454875 456263 456382 456507 456941 456982 457565 459261 459404 459711 459826 460453 461760 462696 462911 463379 464601 465093 466033 467373 467804 469102 469112 469410 469493 470118 471002 471582 472222 472263 472295 472322 472525 472530 473239 474682 475025 475061 475225 475256 475467 475720 476567 478140 478409 478655 479271 480395 482723 483389 483578 483579 487297 492183 492470 499871 502302 506876 510608 510809 511338 515263 517915 524204 524783 529333 542651 558359 563839 586584 680923 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"белый"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"белый"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.25 ms (0.81%) |
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.