GET https://search.jues.net/search/embeds/4?q=asian%20mother

Query Metrics

7 Database Queries
7 Different statements
150.51 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
124.84 ms
(82.94%)
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
  20948
  21500
  61536
  153364
  167756
  384492
  385448
  385476
  387018
  389475
  396922
  408047
  409878
  419850
  423129
  443046
  444773
  447853
  454953
  456862
  465076
  469366
  469549
  475448
  475938
  492413
  492646
  496441
  510595
  512182
  512197
  512199
  515606
  515702
  515734
  522123
  525192
  531222
  541598
  545628
  549308
  550616
  550643
  550996
  551963
  551966
  551971
  552040
  552896
  552913
  554432
  557505
  557509
  559889
  559923
  562847
  562900
  565979
  565980
  565985
  565998
  566000
  566011
  566015
  566016
  568552
  586542
  590934
  601081
  605848
  613163
  614529
  615767
  619412
  619458
  619487
  622266
  630492
  630521
  639310
  641663
  643383
  650933
  672251
  672258
  697354
  712154
  712884
  714848
  722187
  726647
  741631
  750816
  760674
  770665
  771792
  775584
  776189
  785024
  789760
  789999
  795539
  802671
  804465
  807641
  807915
  808775
  810813
  812975
  813226
  813507
  815219
  815454
  815674
  815893
  816360
  817920
  818371
  819082
  822721
]
15.41 ms
(10.24%)
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
  562847
  819082
  566015
  554432
  541598
  815893
  818371
  454953
  712884
  714848
  722187
  586542
  630492
  614529
  630521
  775584
  776189
  812975
  760674
  807915
  810813
  515734
  396922
  566011
  423129
  443046
  515606
  641663
  807641
  456862
  465076
  605848
  619487
  639310
  795539
  813507
  808775
  770665
  167756
  475448
  531222
  590934
  475938
  153364
  492413
  552896
  551963
  552040
  613163
  615767
  444773
  419850
  566000
  822721
  512182
  559889
  565985
  643383
  789999
  726647
  384492
  447853
  469366
  815454
  741631
  512197
  512199
  551971
  550643
  550616
  619458
  469549
  510595
  492646
  712154
  552913
  622266
  601081
  562900
  565998
  389475
  815674
  697354
  813226
  817920
  815219
  566016
  545628
  650933
  672258
  789760
  771792
  802671
  804465
  387018
  409878
  816360
  557509
  565980
  557505
  61536
  549308
  21500
  385448
  496441
  619412
  785024
  408047
  385476
  20948
  515702
  525192
  550996
  568552
  750816
  565979
  551966
  672251
  522123
  559923
]
2.99 ms
(1.98%)
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
  20948
  21500
  61536
  153364
  167756
  384492
  385448
  385476
  387018
  389475
  396922
  408047
  409878
  419850
  423129
  443046
  444773
  447853
  454953
  456862
  465076
  469366
  469549
  475448
  475938
  492413
  492646
  496441
  510595
  512182
  512197
  512199
  515606
  515702
  515734
  522123
  525192
  531222
  541598
  545628
  549308
  550616
  550643
  550996
  551963
  551966
  551971
  552040
  552896
  552913
  554432
  557505
  557509
  559889
  559923
  562847
  562900
  565979
  565980
  565985
  565998
  566000
  566011
  566015
  566016
  568552
  586542
  590934
  601081
  605848
  613163
  614529
  615767
  619412
  619458
  619487
  622266
  630492
  630521
  639310
  641663
  643383
  650933
  672251
  672258
  697354
  712154
  712884
  714848
  722187
  726647
  741631
  750816
  760674
  770665
  771792
  775584
  776189
  785024
  789760
  789999
  795539
  802671
  804465
  807641
  807915
  808775
  810813
  812975
  813226
  813507
  815219
  815454
  815674
  815893
  816360
  817920
  818371
  819082
  822721
]
2.01 ms
(1.33%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.92 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "asian mother"
]
1.88 ms
(1.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "азиатк мам женщин"
]
1.47 ms
(0.98%)
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.