SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001488s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473541 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473541 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267702,585015,28279,751675,128290,52838,388379,122916,269837,291002,577708,204797,138073,588327,613003,883582,1048871,820245,814952,837864,467001,888988,617402,720100,624942,625708,114682,1001496,800655,827165,48651,623258,6726,955278,869693,971582,288732,62544,698424,172697,649901,365631,602819,408289,719958,118855,699515,995197,773850,1026516,939791,918324,450754,104265,642464,522760,131130,773727,20258,918875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]