SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416581 LIMIT 1 [ RunTime:0.000533s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416581 [ RunTime:0.005741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812619,1836,983870,334270,171609,387777,991808,661784,116815,884366,774958,769219,284053,305838,440990,1011758,311957,545845,294207,1002737,250762,392726,613896,531551,369721,540162,131717,55029,636656,860209,958042,33034,342910,756619,861637,623578,86617,263732,317051,890966,299875,521547,139816,487316,269375,1018000,18932,962401,831145,593300,333841,1042617,54833,231416,279096,736635,443482,974896,125026,1033618) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001654s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]