SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417954 LIMIT 1 [ RunTime:0.000471s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417954 [ RunTime:0.003410s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49961,293478,269160,524011,907768,153901,487389,88655,882638,864676,821616,412444,743204,1042938,980088,268547,380718,104071,536761,942338,185317,618401,72986,933949,711815,989004,400815,812765,719341,493497,79330,906566,700929,443601,724197,623258,233482,115948,321681,912453,990934,150642,1001384,661604,206433,284089,863576,98088,90070,535809,492379,219942,481668,975761,674738,337835,149850,976575,632971,1036009) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]