SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001491s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548699 LIMIT 1 [ RunTime:0.001089s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548699 [ RunTime:0.003105s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409575,764071,298582,203054,288666,214432,987398,299277,205719,203066,1036206,829945,487084,709595,818545,167853,827141,839037,257946,347174,398639,1032465,919520,119349,364927,967360,459984,556299,975420,382135,761501,38265,235943,94718,127894,445937,847436,453287,953857,83196,584775,797823,48736,844247,535629,800550,805921,759142,657748,823114,436643,902688,769084,738060,976601,142050,244829,270487,480024,368671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]