Query Metrics
7
Database Queries
7
Different statements
158.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.50 ms (78.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 401773 418264 423329 423350 425486 427182 427306 455507 455974 458089 458240 458827 471978 473293 478543 478558 480702 482895 484022 490253 492040 493299 496527 496528 497850 501203 501209 502541 502549 504909 507182 507310 507312 509707 509713 511152 514842 515396 516874 517425 520208 520229 520485 524417 525378 525923 526621 526720 531966 535049 536032 538064 540513 543392 553000 562953 563634 566112 578812 582821 585281 586574 587300 589196 590188 591415 591416 593835 593872 595099 604191 604702 605601 605646 605703 612804 613599 620725 624975 626811 628426 630915 632724 632924 633899 633972 635422 635490 635582 636367 636579 636598 639044 645201 653876 654273 654295 656815 679567 691713 697006 715581 715583 725527 761293 768581 785657 813018 ] |
||||||||||||||||||||||||||||||
|
24.34 ms (15.39%) |
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 691713 715583 605601 633899 587300 589196 761293 813018 493299 401773 497850 525923 531966 478543 654295 654273 645201 605646 590188 725527 785657 478558 418264 517425 482895 502549 612804 538064 586574 458827 458240 496528 632924 620725 633972 768581 458089 484022 514842 536032 501203 507182 656815 715581 585281 613599 635582 604702 624975 635422 425486 595099 520485 697006 578812 632724 635490 526720 490253 553000 630915 427306 471978 520208 496527 543392 653876 636367 455507 526621 511152 520229 605703 639044 473293 455974 492040 626811 636598 502541 509707 535049 593835 636579 423350 516874 507310 604191 480702 504909 562953 507312 525378 427182 582821 593872 540513 515396 566112 563634 591416 501209 524417 509713 679567 423329 591415 628426 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.74%) |
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 401773 418264 423329 423350 425486 427182 427306 455507 455974 458089 458240 458827 471978 473293 478543 478558 480702 482895 484022 490253 492040 493299 496527 496528 497850 501203 501209 502541 502549 504909 507182 507310 507312 509707 509713 511152 514842 515396 516874 517425 520208 520229 520485 524417 525378 525923 526621 526720 531966 535049 536032 538064 540513 543392 553000 562953 563634 566112 578812 582821 585281 586574 587300 589196 590188 591415 591416 593835 593872 595099 604191 604702 605601 605646 605703 612804 613599 620725 624975 626811 628426 630915 632724 632924 633899 633972 635422 635490 635582 636367 636579 636598 639044 645201 653876 654273 654295 656815 679567 691713 697006 715581 715583 725527 761293 768581 785657 813018 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hotwife amateur"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hotwife любительск"
]
|
||||||||||||||||||||||||||||||
|
1.20 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hotwife любительск"
]
|
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.