SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001770s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 582201 LIMIT 1 [ RunTime:0.002133s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 582201 [ RunTime:0.003049s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302203,563636,160498,891118,558765,922049,203611,941425,408776,123177,225749,82106,187166,680930,399993,431813,980348,485123,905078,1048100,403905,884782,807267,15504,990935,851238,270310,212361,215863,444474,259240,279257,849018,345381,366857,75166,159238,185823,231679,607350,169171,795469,103150,33953,835480,472506,404618,992613,55103,109996,655673,133759,127584,978111,896403,927057,938644,998249,888139,956302) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 582201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 582201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]