0.93 ms (29.21%)
|
1 |
SELECT t0.id AS id_1, t0.slug_fr AS slug_fr_2, t0.mana AS mana_3, t0.description_fr AS description_fr_4, t0.power AS power_5, t0.legend AS legend_6, t0.rapide AS rapide_7, t0.position AS position_8, t0.reputation AS reputation_9, t0.slug_en AS slug_en_10, t0.name_en AS name_en_11, t0.name_fr AS name_fr_12, t0.description_en AS description_en_13, t0.hp AS hp_14, t0.movement AS movement_15, t0.active AS active_16, t0.price AS price_17, t0.edition_id AS edition_id_18, t19.id AS id_20, t19.name AS name_21, t19.date AS date_22, t19.slug AS slug_23, t19.code AS code_24, t19.name_en AS name_en_25, t19.active AS active_26, t19.name_fr AS name_fr_27, t0.eglise_id AS eglise_id_28, t0.card_type_id AS card_type_id_29, t0.artist_id AS artist_id_30, t0.product_id AS product_id_31 FROM cards t0 LEFT JOIN `set` t19 ON t0.edition_id = t19.id WHERE t0.artist_id = ? AND t0.active = ? ORDER BY t0.name_fr ASC
SELECT t0.id AS id_1, t0.slug_fr AS slug_fr_2, t0.mana AS mana_3, t0.description_fr AS description_fr_4, t0.power AS power_5, t0.legend AS legend_6, t0.rapide AS rapide_7, t0.position AS position_8, t0.reputation AS reputation_9, t0.slug_en AS slug_en_10, t0.name_en AS name_en_11, t0.name_fr AS name_fr_12, t0.description_en AS description_en_13, t0.hp AS hp_14, t0.movement AS movement_15, t0.active AS active_16, t0.price AS price_17, t0.edition_id AS edition_id_18, t19.id AS id_20, t19.name AS name_21, t19.date AS date_22, t19.slug AS slug_23, t19.code AS code_24, t19.name_en AS name_en_25, t19.active AS active_26, t19.name_fr AS name_fr_27, t0.eglise_id AS eglise_id_28, t0.card_type_id AS card_type_id_29, t0.artist_id AS artist_id_30, t0.product_id AS product_id_31 FROM cards t0 LEFT JOIN `set` t19 ON t0.edition_id = t19.id WHERE t0.artist_id = 1 AND t0.active = 1 ORDER BY t0.name_fr ASC;
|