SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506071 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506071 [ RunTime:0.002036s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920315,843238,663021,741006,8378,722745,43840,620875,204281,321921,361417,265155,470467,809206,332185,692468,233138,172991,418000,889936,478055,771833,903686,529346,236514,548794,130455,1015234,523185,620275,406101,996985,950800,398485,811815,922298,97915,799181,445711,36447,806613,378327,366410,953494,386606,845096,640102,192342,514187,908269,790617,44434,857343,586069,668366,543859,984112,279834,344337,758446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]