SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477963 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477963 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368378,19098,209774,302847,590468,518365,292574,457887,91698,441625,1001760,864229,785311,23425,812559,584703,344912,146145,143070,638001,794597,828214,881566,124519,708527,33037,230223,590327,79317,929081,632209,784712,748659,887266,891161,19022,604587,162981,81090,404032,484816,683686,1032561,163342,478972,731598,589882,665516,68223,1025555,263288,567033,890811,1031704,765701,59339,969932,169466,912506,513830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]