SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103883 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103883 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (609790,552270,902148,601502,3587,410013,436878,285970,1007496,1038501,780332,123353,144043,365398,562003,670208,134826,262092,536657,230768,798197,910275,723544,479566,183058,161509,911147,166676,871583,402222,527877,623466,1040521,953967,811465,992395,501163,112795,753304,868274,2357,537868,1010719,391729,515331,972744,146671,194965,809306,11488,307756,813313,385440,213371,211515,740671,92981,461371,251362,927218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]