SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412068 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412068 [ RunTime:0.002068s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485580,949917,285006,254454,783528,233298,622394,682202,863035,343337,162598,139716,810018,279615,150328,580347,760769,425071,910579,82436,723079,264067,951590,990268,942522,317252,189713,950427,164761,596639,102580,778618,563292,76224,158560,153488,508707,1048848,988070,456058,897905,903605,762707,135369,180427,254296,763364,267221,312197,893865,920293,683715,191331,38713,224482,50384,349311,652495,629837,121443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001762s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]