SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80141 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80141 [ RunTime:0.001914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534468,261697,376729,801567,946131,737274,195254,924544,122709,443720,370488,1032669,971756,371703,90181,692793,1000250,775543,584627,241875,665944,409279,235658,806559,145594,94441,788710,879893,774795,101173,172350,756983,427939,890118,376657,608762,891231,87425,982371,97594,677113,643801,286043,386295,10718,412611,1013925,166127,451591,367550,684140,918876,149547,888688,995345,397029,2054,682672,152296,268691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]