SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349227 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349227 [ RunTime:0.004800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35541,817205,223976,305627,940053,531286,866884,995396,1048530,836133,539691,147845,806485,349952,614754,34033,624865,149342,959282,163048,376818,602887,859319,1031837,980666,674883,176114,548384,655620,52560,534898,951603,981150,391260,474531,622421,555365,728098,355770,134567,668663,162462,341629,1006770,200360,613778,1008930,651001,331091,507830,414490,529312,831395,677322,468558,651743,754003,692893,547179,404749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349227 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349227 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]