SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018147 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018147 [ RunTime:0.002301s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470456,702030,505674,846383,835060,102943,308932,178005,452133,710011,651802,853814,822224,735184,643265,476185,595284,757757,119095,244581,690322,602795,9118,419905,958055,1000081,522407,362549,321769,134932,477362,810337,52606,519112,164583,1042376,265077,618284,825934,374765,136052,957931,116010,156331,593368,629913,973761,591180,760977,919566,472965,239252,819993,125780,220543,278929,1000110,337468,232938,873388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018147 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018147 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]