SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547826 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547826 [ RunTime:0.001481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413650,1016878,297543,204255,390194,158976,178309,526797,357891,790031,384875,62842,972095,85121,457259,735753,5489,760290,368676,893891,689348,908026,56022,430102,574095,274997,69084,271913,501160,854448,765883,434467,338089,1032717,906720,169146,420347,540613,394077,670786,350743,1001997,826279,255104,873984,794682,903186,704220,912594,381478,573429,457294,1037218,514819,680145,922609,570928,366568,803505,943409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547826 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547826 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]