SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286188 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286188 [ RunTime:0.003515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113418,1024669,470193,1028484,607793,932755,530080,316716,739685,926051,170255,428510,1114,382589,945775,999739,134141,617759,50574,949804,174593,965869,1045395,273418,258204,170506,268549,546253,843851,561612,945461,280560,412777,488423,685113,897703,1012742,1044700,1024515,1048089,1423,884554,615305,238924,535223,445411,207731,16345,653140,995425,844665,458594,326209,437033,656265,699240,459933,579388,595441,531813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]