SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001418s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 180210 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 180210 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964434,1043171,35125,130573,391479,678127,521940,521617,251142,555593,784292,643119,795116,918939,1007139,885346,928707,357186,848275,914495,893293,48796,592135,871339,335796,1030119,1006426,408115,380284,715124,319425,180762,414946,629750,24381,671874,871355,171192,377451,196861,324689,86415,1046377,973359,380145,73052,115087,597028,30194,858180,971646,688757,1028113,377890,836644,958029,322405,227553,776986,159624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 180210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 180210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]