SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541710 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541710 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (228620,722327,134512,459919,995254,1018494,611891,642964,505579,287908,729618,469125,631393,853920,1030364,646059,339992,751024,172766,131032,470304,1038088,144528,63444,546296,700216,414762,20667,571843,753200,1008701,999447,515061,573680,699770,952494,1021634,408965,976443,352300,437566,269490,325554,658448,448309,643088,704010,982323,969958,975724,462011,100952,807413,572730,908598,16878,15240,142119,586070,12743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000719s ]