SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559064 LIMIT 1 [ RunTime:0.001294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559064 [ RunTime:0.003195s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563273,858094,904429,512982,101753,442827,1042907,494246,723101,542759,217673,146262,56756,696803,831173,342107,1045110,330427,1001285,812239,879921,149717,622478,801291,769183,595968,37379,113343,1009322,824945,945292,817515,85914,940477,1023967,307772,802496,419775,120312,301719,483411,222239,481551,748761,679110,785782,394640,145185,574397,621799,70895,370069,494072,318001,148247,390792,623817,719752,83498,60356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]