SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002943 LIMIT 1 [ RunTime:0.000532s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002943 [ RunTime:0.002821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (965969,500213,345266,1039288,695986,909428,778970,522208,407354,382553,591296,447651,429107,183012,524446,899037,821035,631450,552987,889132,581123,75523,726444,486546,118247,991655,614671,211851,1038224,119436,617571,650583,314018,369198,791644,679107,156676,397700,251112,601863,968044,785989,473686,862483,752604,146533,30722,412976,3824,10205,1007230,671765,785412,162795,544933,1038011,946223,923764,786929,46488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000878s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001036s ]