SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001572s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586881 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586881 [ RunTime:0.002239s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (448459,952661,76612,772555,732568,529158,544515,642123,127824,283002,597288,351814,584677,65591,43789,775265,669261,979315,481988,317139,444232,92046,362443,396289,190565,956396,749924,737181,242086,757508,707525,283479,565754,357725,963243,474413,1007487,58997,289335,392824,312147,463233,1023996,429105,275385,873816,840044,577018,911651,380789,1018622,709316,748474,85861,78913,906398,578120,771884,133618,314193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]