SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002036s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41596 LIMIT 1 [ RunTime:0.001151s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41596 [ RunTime:0.001839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248207,211058,1035367,84350,699256,752381,826506,591471,646914,741801,150075,22906,135506,396984,1019014,388466,909231,688493,1000528,610077,792734,22747,924183,573491,108511,869551,255051,918563,448920,104226,224002,334059,449627,389098,278391,700801,675247,246308,373027,352919,292613,765902,864066,494260,606166,232662,475208,832989,1007036,449735,520255,918426,890839,137139,461406,854071,302933,366416,454170,975182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]