SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512422 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512422 [ RunTime:0.002304s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269963,662706,723571,189134,645960,247828,964568,227971,968731,902013,290555,810599,613642,799329,465196,624786,437107,831056,720936,258663,98126,188533,17713,421080,476674,860907,256744,866110,159632,387151,75061,30386,590082,320067,593548,3207,229277,905424,837221,536837,992473,918749,466070,618282,771382,577764,185161,899881,675333,654585,423665,961928,995754,142309,596777,149564,936698,528880,1017852,234768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]