SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002065s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480320 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480320 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (800885,129212,512462,566277,767536,822775,147145,726689,288187,161218,472622,1010384,694653,897399,546010,564519,265013,544827,124883,424554,720996,984318,450401,45696,957974,1024668,388966,872331,275491,421226,1001127,626354,466951,537558,540889,77388,154010,733045,1046428,246576,473454,855732,1029470,269314,1042299,422113,855903,996226,179353,227687,773881,203515,473495,387265,732208,341318,1002378,658741,892079,409951) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]