SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 369064 LIMIT 1 [ RunTime:0.004536s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 369064 [ RunTime:0.006235s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (673684,501745,308480,676014,455642,74631,570971,189164,620179,967629,833388,282001,711734,7656,579607,692949,953047,241804,391516,584725,30006,725104,596414,109269,744606,459700,281401,730513,188012,955699,664088,706168,417552,211201,123859,996300,809839,594304,1043244,130650,1008663,962170,884513,1018421,718388,748472,419488,419729,565882,16986,181315,403891,106658,200260,1020678,591376,540917,533849,559067,352735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 369064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 369064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002712s ]