SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518951 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518951 [ RunTime:0.002153s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440667,449645,188745,7428,1037790,881233,781251,16324,877752,779838,840431,792302,959360,979910,400410,780005,90989,27607,1020720,188015,995653,418511,651690,39076,572594,299465,755210,750387,860619,966744,1027861,208449,172637,547820,229262,916289,705873,82157,694019,180279,532463,896077,255004,537318,268756,704454,276260,837766,236229,453313,1035508,272509,359912,284335,843889,769741,539198,334705,307197,923634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]