SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517530 LIMIT 1 [ RunTime:0.002919s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517530 [ RunTime:0.002439s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502290,39141,847637,899980,551598,328632,504737,767063,619512,246390,157167,666873,962552,270976,920323,367812,32619,585176,10017,649336,176367,618279,282700,906486,241100,567979,10735,555646,573276,341462,687005,26720,650762,702848,817360,859480,889096,364823,541898,600156,127023,98149,559210,940469,997153,1030405,654161,356982,623086,541391,661443,729826,967002,1004091,8385,867506,128360,610889,793610,569152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517530 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517530 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]