SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 94678 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 94678 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478990,303255,857837,569119,100807,581933,462298,405948,834121,552118,685964,1019190,914936,694359,622630,565136,680925,131146,806236,340838,395970,205435,996145,867178,190692,818268,240103,742063,858986,952722,258528,563134,203350,992121,432289,618993,259049,276837,557780,788117,476074,186250,711581,963290,334535,32722,284164,134868,789963,586176,785080,12848,755806,972227,239115,713558,20531,223434,536472,383931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 94678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 94678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]