SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017098 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017098 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612912,924896,281255,56450,765894,825379,1043084,501791,388652,479712,728700,157757,870781,19291,63555,824428,191998,386808,533510,680947,920832,721051,559001,294558,946479,682978,605426,142244,768337,882478,252940,905499,629800,1041338,352421,427653,464480,508555,918194,502856,777218,982751,1045538,212273,796866,1025426,927248,865040,52897,731514,394936,1030091,519138,650982,22474,819645,615782,924769,243969,1023369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]