SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200589 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200589 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (632201,677815,837323,243819,1040432,65448,5549,238817,582169,949266,1035110,213306,224366,135721,475488,972428,350009,991575,103292,432694,610270,680080,896181,753961,258693,875700,1034229,976120,834187,365425,54375,794812,172146,841624,342447,297837,946719,646554,951411,311379,173734,113103,553959,161995,266710,783414,115713,380640,604400,487117,80020,150977,950663,410772,296160,481778,997333,767231,315868,704019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200589 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200589 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]