SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517938 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517938 [ RunTime:0.002489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796804,298101,626081,570865,990942,915281,254205,314968,814335,1046393,1010691,446844,649698,573509,343935,342018,976121,1034626,944594,366154,171570,442837,351895,971488,293711,523221,384796,171887,266827,840253,672194,530819,239309,158179,442514,570083,861892,618829,715607,958118,229116,115013,725884,889975,932018,341171,431429,121870,1011034,663408,446412,690051,127650,805759,221026,297674,538105,991784,547404,938148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]