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` = 65383 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 65383 [ RunTime:0.002539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037833,688090,240322,361574,1015055,214981,13714,114422,857099,860535,4072,438847,954056,681844,599773,634673,723744,79070,638014,919765,453253,416017,170309,887616,572514,7285,932619,785642,97897,336279,204843,131320,695282,493261,615197,372788,698855,773188,883452,949659,777317,702581,962687,186273,351997,508673,767786,630153,530722,710122,464656,354153,767368,610704,989201,214089,239205,788886,990613,881681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 65383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 65383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]