SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002428s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 164208 LIMIT 1 [ RunTime:0.000572s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 164208 [ RunTime:0.002328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205540,802542,567447,336235,770184,287482,773982,510188,867980,406517,938743,623279,303894,185894,381133,973149,596133,909973,619978,248523,335515,840154,131636,647209,943331,488704,574626,239947,421175,714483,676360,695937,996443,251093,130503,843892,223148,618836,174928,763728,830466,784176,679872,27011,426008,595180,1022953,653823,850965,1026959,442965,265441,535890,277033,749189,959081,692179,251365,934434,250207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 164208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 164208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]