SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527091 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527091 [ RunTime:0.006292s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715546,415646,1188,134675,764277,362989,2028,298435,154637,999890,594271,951262,807209,791824,539916,870437,918669,758368,142986,459655,549761,1005813,280573,829188,71040,837396,843386,630270,596311,620409,634671,48635,176102,817846,815963,421203,304899,74944,258736,220443,987172,1032081,223727,763897,299717,641125,201263,590731,714855,981662,795348,831220,636254,39615,231639,503061,256142,158727,322599,222537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002825s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]