SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010798 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010798 [ RunTime:0.001770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (740396,17394,15336,927444,165140,473127,656164,736782,329791,911002,265941,615901,514023,505672,561184,877932,775595,425680,554619,634613,181633,758453,338010,458464,667306,190546,204738,287062,681285,265796,943563,937518,22275,468136,268052,326405,1024356,654228,809719,1008890,713338,472908,609478,234555,90174,828732,477407,1020124,694427,948433,331497,872704,204386,24923,483553,878217,378670,384086,915325,733558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]