SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417153 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417153 [ RunTime:0.003007s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (347036,592053,208648,519282,840811,114246,460058,673294,819419,1005889,733684,599841,528801,775441,1009892,579796,494519,747624,586785,259708,715275,1015448,763049,986000,1020157,694933,176062,928852,962269,787895,613377,465423,245591,134935,102815,510194,1022228,178708,586577,145992,799300,987496,10515,808432,572279,83727,308421,481442,514907,707337,84398,1003404,274742,642282,1003615,74052,524199,551416,532640,345251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002883s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417153 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417153 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]