SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508001 LIMIT 1 [ RunTime:0.004285s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508001 [ RunTime:0.002339s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399009,5716,316170,853656,137345,87286,662616,77621,18661,461920,935259,110392,59543,513384,264524,157243,475548,438840,713545,646862,785876,122917,6573,298709,539251,423008,590851,488133,52194,986838,1014519,488994,1028193,137020,918975,263683,737377,505023,189785,345282,244729,849146,315521,541834,260467,29127,453534,751973,361897,856490,998298,316855,332630,419827,465199,308538,465978,74856,655495,473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001799s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]