SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591171 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591171 [ RunTime:0.004029s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582814,652696,808678,126946,978532,21062,813996,499558,758381,359109,544134,980440,858331,564048,969124,546588,998309,416717,846831,100122,41030,455569,1009010,770587,702049,910542,163565,935440,992387,1012444,575692,863893,933195,67455,753548,292014,146700,1004086,587935,642155,429451,918694,56244,433573,511519,137330,637166,228102,113118,117991,555907,447431,710125,934990,971861,351930,389711,179846,993527,887125) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001900s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]