SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314264 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314264 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793013,138864,802005,72779,795325,432975,925637,609741,716259,446800,608025,243862,186031,436764,321978,467597,407998,94473,292697,567260,809900,443287,160502,31181,544195,223754,533862,614245,147835,490898,14027,898102,942020,462693,263161,109294,155311,409714,92646,115544,757516,702115,766698,470711,701596,404094,841546,631144,317200,929449,996628,119184,227455,953479,505160,360255,375276,1045509,192531,339294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314264 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314264 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001173s ]