SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.008803s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 389180 LIMIT 1 [ RunTime:0.002793s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 389180 [ RunTime:0.004472s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201579,378520,357668,1130,12123,806215,962465,768238,26411,373074,357281,441805,922607,640555,98984,64514,453496,546986,164028,1048805,914522,123201,1021996,651596,280732,810798,267718,352398,438512,960273,119989,729298,449310,864615,469638,24126,474257,328834,907904,1001580,785982,796700,9196,727930,130411,222398,217428,291589,963250,727513,79825,350687,970244,849361,373433,153087,32916,641759,418026,658863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 389180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 389180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005287s ]