SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447433 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447433 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672965,956493,239249,679159,668238,501854,223177,83007,970528,103238,918600,180267,596400,292929,566500,647129,4781,916312,76922,414944,96064,485370,842252,311427,989896,513785,96527,857994,207073,943645,913769,765405,543506,837973,1005023,771168,940052,359209,461152,278461,438346,749930,388605,697395,697255,410436,324800,196460,899684,260175,29224,530248,884024,25134,621309,893807,1007281,244265,701940,221169) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]