SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410691 LIMIT 1 [ RunTime:0.001057s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410691 [ RunTime:0.002674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542818,126350,596142,271940,914451,159135,177456,494393,854778,176519,219631,348973,972911,810331,890877,439190,118604,393925,180716,184351,984469,386258,435862,983011,725603,896417,450416,363908,176720,409582,358867,327309,397779,164025,403803,419128,236275,54317,348061,392614,918429,422992,545207,289657,433069,935238,496268,761611,933751,851757,117708,18061,267060,998785,963945,652617,914895,927978,886498,855941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]