SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404889 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404889 [ RunTime:0.001974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417298,1022900,802563,17608,902128,225907,314633,208730,745693,629625,318047,212205,943846,1033669,356288,1008499,24765,827064,627132,758453,598304,402087,5324,802402,1043901,528415,540660,862164,168396,949025,695415,489813,659950,812193,876257,888322,425953,733970,181295,1032332,784541,650263,651016,1046835,595438,967720,781862,672708,999287,338337,378709,157349,60235,428065,355196,375321,218557,114430,854255,164097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404889 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404889 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]