SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507938 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507938 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477471,218199,244514,174652,396935,400030,1033299,430368,187320,971862,76601,532911,538116,657835,537628,693648,11054,409920,124183,972511,652445,549735,909313,135325,928497,825305,375876,458074,718607,859184,174947,539291,764394,500699,770137,386019,438150,123022,905544,271125,1023884,555299,613739,966707,1040489,962117,272864,611876,411174,741186,401040,194285,243475,434204,846112,1833,957155,337203,392346,778757) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]