SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007918s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49812 LIMIT 1 [ RunTime:0.006471s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49812 [ RunTime:0.008261s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536627,43980,503812,681641,169086,38301,775540,175208,230939,54195,966019,877271,117702,875876,427682,1024854,161934,269134,799664,149896,872232,442734,224397,67695,341652,234563,753504,106287,1017763,713284,75313,516131,643650,618272,644450,213858,1009153,1030359,484446,1027783,867416,514229,673211,729487,650394,601061,823656,145920,278409,769652,859219,18116,908865,794862,788938,155927,262913,803722,642524,578502) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.019006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.009661s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003064s ]