SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334960 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334960 [ RunTime:0.003041s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010522,622907,750908,83066,18107,8524,143383,84646,654733,874039,293252,34095,401340,613214,225325,425733,259910,882667,22856,3229,162022,274303,321073,497908,890988,571794,905934,310086,197283,54118,554920,109921,469667,1045937,81554,502002,301851,150599,416160,631919,730393,541836,689412,74559,771125,896531,998860,172594,493818,324198,867921,74953,188545,1005171,11008,161353,354867,223865,418961,461247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334960 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334960 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003268s ]