SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 576212 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 576212 [ RunTime:0.003631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520838,944111,655070,279677,470143,830685,491304,27673,329003,5245,1040796,303193,81422,22018,616871,675248,553285,646093,898327,667108,871533,478372,833816,984576,485244,131476,760559,301094,253533,516856,57507,852297,348574,613555,210490,149488,137197,423156,333254,850327,114137,395731,895275,201923,442817,861635,423120,778823,606668,15914,324587,372434,826359,270495,842935,367632,698734,543246,466793,407180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 576212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 576212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001829s ]