SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003534 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003534 [ RunTime:0.004960s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (268200,1019748,17871,459378,392882,883162,831443,303214,719031,544880,503489,325978,944851,934217,337498,859256,678887,128797,668511,327516,924647,8131,665642,289224,533584,618246,679080,945439,678444,474944,836683,325633,315152,732616,767281,892473,530575,27748,281417,752885,602201,149915,601967,615313,63554,167337,498688,316950,889076,877491,716019,932684,64747,967854,963946,456453,281781,44137,1025484,501776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]