SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002047s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012597 LIMIT 1 [ RunTime:0.000584s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012597 [ RunTime:0.002676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (676433,935581,840536,668510,961227,469588,558857,772328,524460,962404,276011,692567,838790,773590,941582,716733,86918,274753,90642,272686,600537,990994,917782,248891,148635,954188,380415,842763,398641,315394,366384,531427,579598,953742,767192,1038674,803579,584255,1022710,728118,749645,888680,880854,983876,727529,133947,656690,736778,200122,248710,871060,94902,616734,43729,1045692,631798,117810,112017,872066,820075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012597 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012597 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001903s ]