SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001691s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023515 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023515 [ RunTime:0.002593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559404,563717,543238,362819,288227,90848,1046735,433675,802215,298549,517573,629444,413531,192281,767746,486183,209801,558031,175202,794354,904764,793877,26314,785528,526082,875459,372464,742475,293616,1023747,485581,669792,201208,67187,400096,997063,988341,964211,905029,634224,652259,8965,831661,791718,184126,725181,130033,40347,835331,763028,413718,348736,536456,124659,19238,938139,47399,914224,271069,690775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001783s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]