SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981881 LIMIT 1 [ RunTime:0.000640s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981881 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211799,915157,1022887,159710,280551,76382,3093,39031,782766,619634,276604,767350,1004704,574538,849910,961299,83542,1001357,60858,750243,136998,422707,492043,187588,996969,221035,578347,1038512,160295,781749,828131,544960,24186,664673,651648,879400,361986,732188,383816,645403,596971,903319,926698,906605,565815,346321,753793,835609,254355,868084,647824,816808,61194,925716,579107,244686,674507,956358,612972,835631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]