SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003896s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046062 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046062 [ RunTime:0.002587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428906,973984,979687,342061,231902,1015472,1036190,344766,496865,887459,201369,750409,810400,44816,776905,528004,46034,338118,126863,748831,836320,766656,729382,496618,695570,892546,425407,965766,456952,651239,330554,123845,374653,376981,198529,958302,771810,80476,723861,255299,164948,704406,959008,921293,990811,906969,668976,840942,296449,350553,811747,119733,66854,517735,572131,550111,443883,521000,350082,603173) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046062 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046062 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]