SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002418s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450427 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450427 [ RunTime:0.003161s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019741,522012,240414,208725,872837,939153,962875,636704,767483,264409,357147,132703,15136,293182,295095,367400,354377,282302,641394,610027,171879,177592,334544,183043,123530,839707,863320,532786,247019,587452,230066,302774,900012,782463,661444,94041,997870,362118,34517,430516,928123,856330,203629,289006,83850,861312,186919,625308,930900,225469,984468,175887,782892,751940,37250,791313,117345,48721,764754,189460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450427 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450427 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]