SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447841 LIMIT 1 [ RunTime:0.002765s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447841 [ RunTime:0.003600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483728,507531,260140,988023,549408,669126,941843,169754,795416,158151,396062,71142,540303,428296,615839,523036,551116,809435,944522,252351,796514,562760,458737,973558,236432,613223,209353,291461,530305,840452,887627,38466,73095,332954,572858,138974,989737,700901,834904,582782,501276,449566,488401,1039122,548073,502104,168623,622670,290332,53068,699462,418471,792624,919210,336636,1041364,195498,126294,90375,324028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003631s ]