SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011098 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011098 [ RunTime:0.002200s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030456,24920,7136,655815,692760,924884,781394,723134,178668,607857,704919,487692,197986,794067,384863,8780,972458,633617,846832,477128,735400,791441,350843,360156,257293,902415,111691,781658,861731,239408,484986,472869,482827,589420,289222,350555,335460,883355,688260,170372,435390,466229,123436,563114,748730,998990,540520,493905,920532,849791,318126,594485,455859,347869,798920,22015,329885,310376,791015,892950) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]