SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002745s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505309 LIMIT 1 [ RunTime:0.000770s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505309 [ RunTime:0.001838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309993,929386,375757,363586,853369,242591,1015124,750016,517740,287646,149813,380859,857873,160358,450305,814601,350582,931598,571678,545031,28028,645757,979751,903549,307198,688600,1006300,445789,301977,15587,704627,307285,952768,873539,259204,54355,936217,415983,388903,824694,259866,861297,332985,844468,566429,596978,613153,685249,618552,609009,551551,688550,936474,783002,410836,927981,743285,467061,739252,949288) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000779s ]