GET http://fresh.dialerzone.com/en/catalog/parts?categories%5B0%5D=6

Query Metrics

301 Database Queries
10 Different statements
108.59 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_name AS image_name_4, t0.parent_id AS parent_id_5 FROM part_categories t0 WHERE t0.id = ?
Parameters:
[
  6
]
2 5.70 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_name AS image_name_4, t0.parent_id AS parent_id_5 FROM part_categories t0 ORDER BY t0.name ASC
Parameters:
[]
3 0.73 ms
SELECT p0_.part_category_id AS sclr_0, COUNT(p0_.id) AS sclr_1 FROM part_listings p0_ LEFT JOIN part_categories p1_ ON p0_.part_category_id = p1_.id LEFT JOIN makes m2_ ON p0_.make_id = m2_.id LEFT JOIN models m3_ ON p0_.model_id = m3_.id LEFT JOIN vehicle_ranges v4_ ON p0_.vehicle_range_id = v4_.id INNER JOIN users u5_ ON p0_.owner_id = u5_.id INNER JOIN company_profiles c6_ ON u5_.id = c6_.user_id WHERE p0_.status = ? AND c6_.status = ? AND p0_.quantity > 0 AND p0_.part_category_id IS NOT NULL GROUP BY p0_.part_category_id
Parameters:
[
  "active"
  "active"
]
4 4.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_name AS image_name_4, t0.parent_id AS parent_id_5 FROM part_categories t0 ORDER BY t0.name ASC
Parameters:
[]
5 1.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_name AS image_name_4, t0.parent_id AS parent_id_5 FROM part_categories t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  6
  518
  543
  542
  541
  540
  539
  538
  537
  536
  535
  534
  533
  532
  531
  530
  529
  528
  527
  526
  525
  524
  523
  522
  521
  520
  519
  507
  517
  516
  515
  514
  513
  512
  511
  510
  509
  508
  488
  506
  505
  504
  503
  502
  501
  500
  499
  498
  497
  496
  495
  494
  493
  492
  491
  490
  489
  479
  487
  486
  485
  484
  483
  482
  481
  480
  472
  478
  477
  476
  475
  474
  473
  455
  471
  470
  469
  468
  467
  466
  465
  464
  463
  462
  461
  460
  459
  457
  458
  456
  422
  454
  453
  452
  451
  450
  449
  448
  447
  446
  445
  444
  443
  442
  441
  440
  439
  438
  437
  436
  435
  434
  433
  432
  431
  430
  429
  428
  427
  426
  425
  424
  423
  409
  421
  420
  419
  418
  417
  416
  415
  414
  413
  412
  411
  410
  399
  408
  407
  406
  405
  404
  403
  402
  401
  400
  389
  398
  397
  396
  395
  394
  393
  392
  391
  390
  372
  388
  387
  386
  385
  384
  383
  382
  381
  380
  379
  378
  377
  376
  375
  374
  373
  360
  371
  370
  369
  368
  367
  366
  365
  364
  363
  362
  361
  325
  359
  358
  357
  356
  355
  354
  353
  352
  351
  350
  349
  348
  347
  346
  345
  344
  343
  342
  341
  340
  339
  338
  337
  336
  335
  334
  333
  332
  331
  330
  329
  328
  327
  326
  298
  324
  323
  322
  321
  320
  319
  318
  317
  316
  315
  314
  313
  312
  311
  310
  309
  308
  307
  306
  305
  304
  303
  302
  301
  300
  299
  286
  297
  296
  295
  294
  293
  292
  291
  290
  289
  288
  287
  278
  285
  284
  283
  282
  281
  280
  279
  252
  277
  276
  275
  274
  273
  272
  271
  270
  269
  268
  267
  266
  265
  264
  263
  262
  261
  260
  259
  258
  257
  256
  255
  254
  253
]
6 0.42 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  6
]
7 0.34 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  252
  6
]
8 0.38 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  253
  252
  6
]
9 0.35 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  254
  252
  6
]
10 0.38 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  255
  252
  6
]
11 0.34 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  256
  252
  6
]
12 0.38 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  257
  252
  6
]
13 0.34 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  258
  252
  6
]
14 0.37 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  259
  252
  6
]
15 0.37 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  260
  252
  6
]
16 0.34 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  261
  252
  6
]
17 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  262
  252
  6
]
18 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  263
  252
  6
]
19 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  264
  252
  6
]
20 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  265
  252
  6
]
21 0.36 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  266
  252
  6
]
22 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  267
  252
  6
]
23 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  268
  252
  6
]
24 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  269
  252
  6
]
25 0.30 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  270
  252
  6
]
26 0.34 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  271
  252
  6
]
27 0.28 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  272
  252
  6
]
28 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  273
  252
  6
]
29 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  274
  252
  6
]
30 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  275
  252
  6
]
31 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  276
  252
  6
]
32 0.30 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  277
  252
  6
]
33 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  278
  6
]
34 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  279
  278
  6
]
35 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  280
  278
  6
]
36 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  281
  278
  6
]
37 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  282
  278
  6
]
38 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  283
  278
  6
]
39 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  284
  278
  6
]
40 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  285
  278
  6
]
41 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  286
  6
]
42 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  287
  286
  6
]
43 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  288
  286
  6
]
44 0.30 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  289
  286
  6
]
45 0.38 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  290
  286
  6
]
46 0.35 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  291
  286
  6
]
47 0.34 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  292
  286
  6
]
48 0.30 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  293
  286
  6
]
49 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  294
  286
  6
]
50 0.34 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  295
  286
  6
]
51 0.38 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  296
  286
  6
]
52 0.37 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  297
  286
  6
]
53 0.34 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  298
  6
]
54 0.34 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  299
  298
  6
]
55 0.31 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  300
  298
  6
]
56 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  301
  298
  6
]
57 0.34 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  302
  298
  6
]
58 0.35 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  303
  298
  6
]
59 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  304
  298
  6
]
60 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  305
  298
  6
]
61 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  306
  298
  6
]
62 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  307
  298
  6
]
63 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  308
  298
  6
]
64 0.34 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  309
  298
  6
]
65 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  310
  298
  6
]
66 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  311
  298
  6
]
67 0.34 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  312
  298
  6
]
68 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  313
  298
  6
]
69 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  314
  298
  6
]
70 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  315
  298
  6
]
71 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  316
  298
  6
]
72 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  317
  298
  6
]
73 0.30 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  318
  298
  6
]
74 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  319
  298
  6
]
75 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  320
  298
  6
]
76 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  321
  298
  6
]
77 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  322
  298
  6
]
78 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  323
  298
  6
]
79 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  324
  298
  6
]
80 0.31 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  325
  6
]
81 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  326
  325
  6
]
82 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  327
  325
  6
]
83 0.30 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  328
  325
  6
]
84 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  329
  325
  6
]
85 0.30 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  330
  325
  6
]
86 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  331
  325
  6
]
87 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  332
  325
  6
]
88 0.25 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  333
  325
  6
]
89 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  334
  325
  6
]
90 0.28 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  335
  325
  6
]
91 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  336
  325
  6
]
92 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  337
  325
  6
]
93 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  338
  325
  6
]
94 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  339
  325
  6
]
95 0.30 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  340
  325
  6
]
96 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  341
  325
  6
]
97 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  342
  325
  6
]
98 0.31 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  343
  325
  6
]
99 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  344
  325
  6
]
100 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  345
  325
  6
]
101 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  346
  325
  6
]
102 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  347
  325
  6
]
103 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  348
  325
  6
]
104 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  349
  325
  6
]
105 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  350
  325
  6
]
106 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  351
  325
  6
]
107 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  352
  325
  6
]
108 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  353
  325
  6
]
109 0.30 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  354
  325
  6
]
110 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  355
  325
  6
]
111 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  356
  325
  6
]
112 0.28 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  357
  325
  6
]
113 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  358
  325
  6
]
114 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  359
  325
  6
]
115 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  360
  6
]
116 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  361
  360
  6
]
117 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  362
  360
  6
]
118 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  363
  360
  6
]
119 0.31 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  364
  360
  6
]
120 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  365
  360
  6
]
121 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  366
  360
  6
]
122 0.35 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  367
  360
  6
]
123 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  368
  360
  6
]
124 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  369
  360
  6
]
125 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  370
  360
  6
]
126 0.30 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  371
  360
  6
]
127 0.31 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  372
  6
]
128 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  373
  372
  6
]
129 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  374
  372
  6
]
130 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  375
  372
  6
]
131 0.30 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  376
  372
  6
]
132 0.31 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  377
  372
  6
]
133 0.28 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  378
  372
  6
]
134 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  379
  372
  6
]
135 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  380
  372
  6
]
136 0.34 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  381
  372
  6
]
137 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  382
  372
  6
]
138 0.31 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  383
  372
  6
]
139 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  384
  372
  6
]
140 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  385
  372
  6
]
141 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  386
  372
  6
]
142 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  387
  372
  6
]
143 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  388
  372
  6
]
144 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  389
  6
]
145 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  390
  389
  6
]
146 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  391
  389
  6
]
147 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  392
  389
  6
]
148 0.35 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  393
  389
  6
]
149 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  394
  389
  6
]
150 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  395
  389
  6
]
151 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  396
  389
  6
]
152 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  397
  389
  6
]
153 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  398
  389
  6
]
154 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  399
  6
]
155 0.34 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  400
  399
  6
]
156 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  401
  399
  6
]
157 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  402
  399
  6
]
158 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  403
  399
  6
]
159 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  404
  399
  6
]
160 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  405
  399
  6
]
161 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  406
  399
  6
]
162 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  407
  399
  6
]
163 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  408
  399
  6
]
164 0.23 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  409
  6
]
165 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  410
  409
  6
]
166 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  411
  409
  6
]
167 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  412
  409
  6
]
168 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  413
  409
  6
]
169 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  414
  409
  6
]
170 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  415
  409
  6
]
171 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  416
  409
  6
]
172 0.31 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  417
  409
  6
]
173 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  418
  409
  6
]
174 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  419
  409
  6
]
175 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  420
  409
  6
]
176 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  421
  409
  6
]
177 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  422
  6
]
178 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  423
  422
  6
]
179 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  424
  422
  6
]
180 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  425
  422
  6
]
181 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  426
  422
  6
]
182 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  427
  422
  6
]
183 0.30 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  428
  422
  6
]
184 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  429
  422
  6
]
185 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  430
  422
  6
]
186 0.31 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  431
  422
  6
]
187 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  432
  422
  6
]
188 0.30 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  433
  422
  6
]
189 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  434
  422
  6
]
190 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  435
  422
  6
]
191 0.34 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  436
  422
  6
]
192 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  437
  422
  6
]
193 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  438
  422
  6
]
194 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  439
  422
  6
]
195 0.30 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  440
  422
  6
]
196 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  441
  422
  6
]
197 0.31 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  442
  422
  6
]
198 0.30 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  443
  422
  6
]
199 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  444
  422
  6
]
200 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  445
  422
  6
]
201 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  446
  422
  6
]
202 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  447
  422
  6
]
203 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  448
  422
  6
]
204 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  449
  422
  6
]
205 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  450
  422
  6
]
206 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  451
  422
  6
]
207 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  452
  422
  6
]
208 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  453
  422
  6
]
209 0.31 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  454
  422
  6
]
210 0.30 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  455
  6
]
211 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  456
  455
  6
]
212 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  457
  455
  6
]
213 0.34 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  458
  455
  6
]
214 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  459
  455
  6
]
215 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  460
  455
  6
]
216 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  461
  455
  6
]
217 0.30 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  462
  455
  6
]
218 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  463
  455
  6
]
219 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  464
  455
  6
]
220 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  465
  455
  6
]
221 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  466
  455
  6
]
222 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  467
  455
  6
]
223 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  468
  455
  6
]
224 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  469
  455
  6
]
225 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  470
  455
  6
]
226 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  471
  455
  6
]
227 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  472
  6
]
228 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  473
  472
  6
]
229 0.30 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  474
  472
  6
]
230 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  475
  472
  6
]
231 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  476
  472
  6
]
232 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  477
  472
  6
]
233 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  478
  472
  6
]
234 0.34 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  479
  6
]
235 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  480
  479
  6
]
236 0.30 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  481
  479
  6
]
237 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  482
  479
  6
]
238 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  483
  479
  6
]
239 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  484
  479
  6
]
240 0.30 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  485
  479
  6
]
241 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  486
  479
  6
]
242 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  487
  479
  6
]
243 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  488
  6
]
244 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  489
  488
  6
]
245 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  490
  488
  6
]
246 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  491
  488
  6
]
247 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  492
  488
  6
]
248 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  493
  488
  6
]
249 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  494
  488
  6
]
250 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  495
  488
  6
]
251 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  496
  488
  6
]
252 0.31 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  497
  488
  6
]
253 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  498
  488
  6
]
254 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  499
  488
  6
]
255 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  500
  488
  6
]
256 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  501
  488
  6
]
257 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  502
  488
  6
]
258 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  503
  488
  6
]
259 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  504
  488
  6
]
260 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  505
  488
  6
]
261 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  506
  488
  6
]
262 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  507
  6
]
263 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  508
  507
  6
]
264 0.30 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  509
  507
  6
]
265 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  510
  507
  6
]
266 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  511
  507
  6
]
267 0.30 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  512
  507
  6
]
268 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  513
  507
  6
]
269 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  514
  507
  6
]
270 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  515
  507
  6
]
271 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  516
  507
  6
]
272 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  517
  507
  6
]
273 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  518
  6
]
274 0.31 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  519
  518
  6
]
275 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  520
  518
  6
]
276 0.30 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  521
  518
  6
]
277 0.25 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  522
  518
  6
]
278 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  523
  518
  6
]
279 0.30 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  524
  518
  6
]
280 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  525
  518
  6
]
281 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  526
  518
  6
]
282 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  527
  518
  6
]
283 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  528
  518
  6
]
284 0.36 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  529
  518
  6
]
285 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  530
  518
  6
]
286 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  531
  518
  6
]
287 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  532
  518
  6
]
288 0.29 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  533
  518
  6
]
289 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  534
  518
  6
]
290 0.31 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  535
  518
  6
]
291 0.30 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  536
  518
  6
]
292 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  537
  518
  6
]
293 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  538
  518
  6
]
294 0.33 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  539
  518
  6
]
295 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  540
  518
  6
]
296 0.32 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  541
  518
  6
]
297 0.31 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  542
  518
  6
]
298 0.31 ms
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
Parameters:
[
  543
  518
  6
]
299 1.22 ms
SELECT p0_.id AS id_0, p0_.short_description AS short_description_1, p0_.slug AS slug_2, p0_.full_description AS full_description_3, p0_.tags AS tags_4, p0_.catalog_number AS catalog_number_5, p0_.oem_number AS oem_number_6, p0_.article_number AS article_number_7, p0_.condition_type AS condition_type_8, p0_.price AS price_9, p0_.price_new AS price_new_10, p0_.quantity AS quantity_11, p0_.status AS status_12, p0_.created_at AS created_at_13, p1_.id AS id_14, p1_.image_name AS image_name_15, p1_.sort_order AS sort_order_16, p2_.id AS id_17, p2_.name AS name_18, p2_.slug AS slug_19, p2_.image_name AS image_name_20, m3_.id AS id_21, m3_.name AS name_22, m3_.slug AS slug_23, m3_.ext_source AS ext_source_24, m3_.ext_id AS ext_id_25, m4_.id AS id_26, m4_.name AS name_27, m4_.slug AS slug_28, m4_.ext_id AS ext_id_29, v5_.id AS id_30, v5_.year_from AS year_from_31, v5_.year_to AS year_to_32, v5_.generation_name AS generation_name_33, p6_.id AS id_34, p6_.value_text AS value_text_35, p6_.value_number_from AS value_number_from_36, p6_.value_number_to AS value_number_to_37, p6_.value_json AS value_json_38, c7_.id AS id_39, c7_.code AS code_40, c7_.name_en AS name_en_41, c7_.name_es AS name_es_42, c7_.type AS type_43, c7_.sort_order AS sort_order_44, p0_.owner_id AS owner_id_45, p0_.make_id AS make_id_46, p0_.model_id AS model_id_47, p0_.vehicle_range_id AS vehicle_range_id_48, p0_.part_category_id AS part_category_id_49, p0_.dismantled_vehicle_id AS dismantled_vehicle_id_50, p1_.listing_id AS listing_id_51, p2_.parent_id AS parent_id_52, m4_.make_id AS make_id_53, v5_.model_id AS model_id_54, p6_.listing_id AS listing_id_55, p6_.filter_id AS filter_id_56 FROM part_listings p0_ LEFT JOIN part_listing_images p1_ ON p0_.id = p1_.listing_id LEFT JOIN part_categories p2_ ON p0_.part_category_id = p2_.id LEFT JOIN makes m3_ ON p0_.make_id = m3_.id LEFT JOIN models m4_ ON p0_.model_id = m4_.id LEFT JOIN vehicle_ranges v5_ ON p0_.vehicle_range_id = v5_.id LEFT JOIN part_listing_custom_filter_values p6_ ON p0_.id = p6_.listing_id LEFT JOIN custom_filters c7_ ON p6_.filter_id = c7_.id INNER JOIN users u8_ ON p0_.owner_id = u8_.id INNER JOIN company_profiles c9_ ON u8_.id = c9_.user_id WHERE p0_.status = ? AND c9_.status = ? AND p0_.quantity > 0 AND p2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.created_at DESC
Parameters:
[
  "active"
  "active"
  6
  518
  543
  542
  541
  540
  539
  538
  537
  536
  535
  534
  533
  532
  531
  530
  529
  528
  527
  526
  525
  524
  523
  522
  521
  520
  519
  507
  517
  516
  515
  514
  513
  512
  511
  510
  509
  508
  488
  506
  505
  504
  503
  502
  501
  500
  499
  498
  497
  496
  495
  494
  493
  492
  491
  490
  489
  479
  487
  486
  485
  484
  483
  482
  481
  480
  472
  478
  477
  476
  475
  474
  473
  455
  471
  470
  469
  468
  467
  466
  465
  464
  463
  462
  461
  460
  459
  457
  458
  456
  422
  454
  453
  452
  451
  450
  449
  448
  447
  446
  445
  444
  443
  442
  441
  440
  439
  438
  437
  436
  435
  434
  433
  432
  431
  430
  429
  428
  427
  426
  425
  424
  423
  409
  421
  420
  419
  418
  417
  416
  415
  414
  413
  412
  411
  410
  399
  408
  407
  406
  405
  404
  403
  402
  401
  400
  389
  398
  397
  396
  395
  394
  393
  392
  391
  390
  372
  388
  387
  386
  385
  384
  383
  382
  381
  380
  379
  378
  377
  376
  375
  374
  373
  360
  371
  370
  369
  368
  367
  366
  365
  364
  363
  362
  361
  325
  359
  358
  357
  356
  355
  354
  353
  352
  351
  350
  349
  348
  347
  346
  345
  344
  343
  342
  341
  340
  339
  338
  337
  336
  335
  334
  333
  332
  331
  330
  329
  328
  327
  326
  298
  324
  323
  322
  321
  320
  319
  318
  317
  316
  315
  314
  313
  312
  311
  310
  309
  308
  307
  306
  305
  304
  303
  302
  301
  300
  299
  286
  297
  296
  295
  294
  293
  292
  291
  290
  289
  288
  287
  278
  285
  284
  283
  282
  281
  280
  279
  252
  277
  276
  275
  274
  273
  272
  271
  270
  269
  268
  267
  266
  265
  264
  263
  262
  261
  260
  259
  258
  257
  256
  255
  254
  253
]
300 1.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ext_source AS ext_source_4, t0.ext_id AS ext_id_5 FROM makes t0 ORDER BY t0.name ASC
Parameters:
[]
301 0.39 ms
SELECT c0_.id AS id_0, c0_.company_name AS company_name_1, c0_.logo_name AS logo_name_2, c0_.ein AS ein_3, c0_.status AS status_4, c0_.submitted_at AS submitted_at_5, c0_.reviewed_at AS reviewed_at_6, u1_.id AS id_7, u1_.email AS email_8, u1_.roles AS roles_9, u1_.password AS password_10, u1_.is_verified AS is_verified_11, u1_.phone AS phone_12, u1_.address_line1 AS address_line1_13, u1_.address_line2 AS address_line2_14, u1_.city AS city_15, u1_.state AS state_16, u1_.postal_code AS postal_code_17, u1_.is_company AS is_company_18, c0_.user_id AS user_id_19 FROM company_profiles c0_ INNER JOIN users u1_ ON c0_.user_id = u1_.id WHERE c0_.status = ? AND c0_.company_name IS NOT NULL AND TRIM(c0_.company_name) <> '' ORDER BY c0_.company_name ASC
Parameters:
[
  "active"
]

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.