SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470791 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470791 [ RunTime:0.001952s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (616908,409651,123255,866233,218406,482717,681058,925314,35523,895703,873919,346481,555924,74918,686574,310248,39176,459142,889245,719073,483130,508095,847131,6688,763978,770204,854565,53255,427748,479865,688299,60593,166456,1003332,822420,810666,940110,796001,988273,398745,254901,243909,1037655,617925,379787,88252,793709,452192,388020,294082,507653,196936,752855,500530,755870,524084,186796,903245,336913,302379) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]