Query Metrics
7
Database Queries
7
Different statements
163.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.52 ms (82.43%) |
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 475682 519012 538873 538915 541324 541332 541337 541647 541674 542190 542500 542798 542969 543725 543756 544292 544313 544496 545517 546614 547552 547892 548289 548297 549214 549220 549300 549773 550327 551038 554321 556597 557322 558801 559433 560088 560430 561353 562848 563217 563462 563530 563534 566146 566673 566691 566695 566927 566941 567397 567407 567751 568362 572556 572579 573905 573906 573908 575761 576639 576681 576711 577358 577365 577369 577376 578257 581301 581380 581398 581401 584008 586015 589747 590696 590948 592422 592450 592500 592522 595770 595888 598058 603161 605324 605338 607707 619485 621319 622331 622830 625798 649153 649196 651190 653328 659262 670040 670097 671721 671759 672138 690854 692335 692360 694119 694192 694470 694554 699694 703553 706899 709624 720382 724173 726848 729821 744259 788314 790392 ] |
||||||||||||||||||||||||||||||
|
19.82 ms (12.15%) |
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 625798 566146 566927 475682 649196 538873 543725 558801 577358 542500 544292 566941 567407 581380 649153 694470 720382 670097 671721 672138 690854 694192 694554 703553 572579 598058 592422 603161 592522 724173 729821 706899 653328 788314 546614 589747 581401 576711 581398 560088 547892 709624 548297 543756 556597 557322 554321 563462 573908 592450 549220 584008 544496 576639 670040 671759 692335 699694 694119 562848 568362 572556 586015 590948 590696 619485 744259 577365 605338 551038 581301 622331 561353 541332 545517 541674 726848 692360 578257 592500 605324 595888 622830 541324 544313 548289 566695 577376 541337 549300 563534 651190 566691 567397 595770 519012 549214 538915 621319 541647 542190 542969 549773 566673 659262 607707 559433 575761 573905 576681 550327 573906 547552 542798 563217 567751 560430 563530 577369 790392 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.38%) |
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 475682 519012 538873 538915 541324 541332 541337 541647 541674 542190 542500 542798 542969 543725 543756 544292 544313 544496 545517 546614 547552 547892 548289 548297 549214 549220 549300 549773 550327 551038 554321 556597 557322 558801 559433 560088 560430 561353 562848 563217 563462 563530 563534 566146 566673 566691 566695 566927 566941 567397 567407 567751 568362 572556 572579 573905 573906 573908 575761 576639 576681 576711 577358 577365 577369 577376 578257 581301 581380 581398 581401 584008 586015 589747 590696 590948 592422 592450 592500 592522 595770 595888 598058 603161 605324 605338 607707 619485 621319 622331 622830 625798 649153 649196 651190 653328 659262 670040 670097 671721 671759 672138 690854 692335 692360 694119 694192 694470 694554 699694 703553 706899 709624 720382 724173 726848 729821 744259 788314 790392 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ретро маленькая грудь"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ретр маленькая сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.86%) |
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.