SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31701 LIMIT 1 [ RunTime:0.001451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31701 [ RunTime:0.003588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (553442,1026911,807525,877140,134883,525041,425390,889511,760463,531979,404006,499388,468076,536361,16890,18878,1017745,891472,508340,472421,356252,570850,31176,341433,553018,464482,803369,292662,886777,843954,220641,945772,865351,190740,663870,639358,367660,28731,806125,153973,289582,22685,470437,748798,780901,476111,878832,406267,215752,815296,83661,460730,827603,360893,71388,88397,199577,975561,43772,1000088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001647s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000881s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002783s ]