SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201129 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201129 [ RunTime:0.002310s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543566,4270,316247,245055,602353,845838,1009166,990203,1045358,652701,760234,514858,941122,999991,956978,1006873,880171,352373,898389,368039,373687,779769,642746,559220,197578,1047701,869588,915187,64079,638114,818830,153988,497008,823667,545979,276338,57910,677468,371324,99037,782384,392761,962209,922505,552126,846893,190568,226316,522053,31002,136242,484571,28526,397314,71327,335512,221127,211303,1018105,476798) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201129 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201129 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]