SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804010 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804010 [ RunTime:0.001914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (66999,802542,403672,233891,410363,815484,625287,1039146,366498,205728,571144,164393,235416,459802,815623,903564,61114,588541,951911,280673,412433,89303,976314,49886,315763,804987,148900,484494,621045,883427,51033,230286,943502,830216,428006,253752,959415,547253,973141,271188,442759,96418,285591,817526,809460,786350,666846,789822,748283,54979,115683,756363,33185,759217,828579,219792,170095,229709,810711,315585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000893s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]