SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338936 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338936 [ RunTime:0.001553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324694,981094,449013,625911,372921,386441,297513,280855,456656,868898,710474,174954,474167,499371,27895,109431,955422,477251,599296,406534,750235,462011,190887,505550,858415,991756,135140,554474,75024,536365,421061,962961,625844,200300,523242,392349,606039,660039,329803,869589,628212,956792,971056,829124,935000,288203,51336,819607,422279,705445,500988,568031,733894,190332,661301,992636,869864,154725,380746,927418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]