SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 577080 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 577080 [ RunTime:0.002081s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (665192,84009,110618,118724,757460,214667,307823,514348,510817,556533,62672,67056,285163,1021975,899432,354511,499579,428093,667483,546897,871760,842103,440144,51688,762458,358514,462668,895136,174829,223998,627313,739501,422785,732374,51815,49109,266991,657146,492147,931661,675582,738916,539001,793766,643706,463194,527381,495188,397039,24979,316676,667649,482017,1010171,205598,921746,322868,9602,832244,710943) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 577080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 577080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]