SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001453s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414796 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414796 [ RunTime:0.002021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (928963,1018555,281844,1042533,915086,112664,108677,196083,534440,54227,77122,412338,1009917,183948,798602,707531,558243,325760,221206,341278,607262,984919,811272,720648,814576,968095,333921,592476,115016,27751,361745,411435,476577,790318,691988,326733,289969,37575,1014874,729038,683954,942626,724501,179643,387958,60427,786611,239616,177772,953873,592433,28859,768527,250303,609691,543537,309407,820948,398880,845959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]