| すいません、よく分からないので 原文のままあげます
テーブル名は trn_uriage_m と trn_uriage_s です リンクキーは renban です 抽出項目は絞りました
>&DSQL="'trn_uriage_m'.'renban' = 123" >&DSQL="trn_uriage_m.renban = 123" の場合のクエリログ
091219 10:20:33 2 Query SHOW TABLE STATUS LIKE 'trn_uriage_m' 2 Field List trn_uriage_m 2 Query SHOW KEYS FROM `trn_uriage_m` 2 Query SHOW KEYS FROM `trn_uriage_m` 2 Query SHOW TABLE STATUS LIKE 'trn_uriage_s' 2 Field List trn_uriage_s 2 Query SHOW KEYS FROM `trn_uriage_s` 2 Query SHOW KEYS FROM `trn_uriage_s` 091219 10:21:12 2 Query SHOW TABLE STATUS LIKE 'trn_uriage_m' 2 Query SHOW TABLE STATUS LIKE 'trn_uriage_m' 2 Field List trn_uriage_m 2 Query SHOW KEYS FROM `trn_uriage_m` 2 Query SHOW KEYS FROM `trn_uriage_m` 2 Query SHOW TABLE STATUS LIKE 'trn_uriage_s' 2 Query SHOW TABLE STATUS LIKE 'trn_uriage_s' 2 Field List trn_uriage_s 2 Query SHOW KEYS FROM `trn_uriage_s` 2 Query SHOW KEYS FROM `trn_uriage_s` 2 Query SELECT COUNT(*) FROM `trn_uriage_m` A1,`trn_uriage_s` A2 WHERE (trn_uriage_m.renban = 123) AND (A1.`renban`=A2.`renban`) 2 Query SELECT A1.`renban`,A1.`denpyobi`,A1.`tokui_mei1`,A2.`gyo_no`,A2.`syohin_id`,A2.`id_uriage_s` FROM `trn_uriage_m` A1,`trn_uriage_s` A2 WHERE (trn_uriage_m.renban = 123) AND (A1.`renban`=A2.`renban`) 091219 10:26:52 2 Query SHOW TABLE STATUS LIKE 'trn_uriage_m' 2 Query SHOW TABLE STATUS LIKE 'trn_uriage_m' 2 Field List trn_uriage_m 2 Query SHOW KEYS FROM `trn_uriage_m` 2 Query SHOW KEYS FROM `trn_uriage_m` 2 Query SHOW TABLE STATUS LIKE 'trn_uriage_s' 2 Query SHOW TABLE STATUS LIKE 'trn_uriage_s' 2 Field List trn_uriage_s 2 Query SHOW KEYS FROM `trn_uriage_s` 2 Query SHOW KEYS FROM `trn_uriage_s` 2 Query SELECT COUNT(*) FROM `trn_uriage_m` A1,`trn_uriage_s` A2 WHERE ('trn_uriage_m'.'renban' = 123) AND (A1.`renban`=A2.`renban`) 2 Query SELECT A1.`renban`,A1.`denpyobi`,A1.`tokui_mei1`,A2.`gyo_no`,A2.`syohin_id`,A2.`id_uriage_s` FROM `trn_uriage_m` A1,`trn_uriage_s` A2 WHERE ('trn_uriage_m'.'renban' = 123) AND (A1.`renban`=A2.`renban`)
|