SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31964 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31964 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179169,663873,330161,351600,507042,59522,1037538,543231,262846,202756,1024623,621382,113248,683288,908173,333919,956993,443524,84975,200857,790270,565564,951239,370659,262607,113026,317015,980152,322690,54033,839181,1017766,707189,132226,508366,150351,519388,672310,492744,926498,1012699,676,156527,969190,293685,222891,1047660,868697,653375,778827,312018,829185,504675,83639,830190,419393,305380,600634,471797,619806) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]