SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001549s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 170083 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 170083 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474434,434780,250098,678151,29087,943195,592021,324568,206080,1000303,643551,322689,81755,1028103,959857,825031,968584,269030,256899,544096,165105,211296,385879,661301,346506,287710,728172,209452,1024003,963100,654039,997499,258579,438448,727282,357271,721821,820850,154231,147080,809972,50645,1047307,153595,350191,247866,940619,190401,61951,665559,770036,480677,59882,834007,1023107,143377,606766,988040,843201,430215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 170083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 170083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]