SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001637s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516857 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516857 [ RunTime:0.001913s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519330,165029,960263,878372,43083,416487,467449,866244,150302,545637,152792,840176,684158,936113,94328,223648,516439,536164,246562,979537,611511,186325,830402,924466,660743,634441,524843,718870,374978,21985,1034062,650372,874040,749033,887086,287586,295053,927143,287482,337542,713154,997514,984134,783944,549540,778578,977357,851237,586489,1023310,696957,954268,295331,112891,470227,2212,1046059,695926,166174,446988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516857 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516857 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]