SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196094 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196094 [ RunTime:0.002623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513767,790080,608981,706682,1034859,102839,743817,489397,141790,576828,126106,785256,774239,318000,205722,533516,176490,663074,592319,962787,652919,712203,735219,367771,87404,885211,359265,175206,243821,891819,228825,16519,100560,467488,312466,763108,201687,612285,387871,105978,709012,846633,272513,37232,714598,567011,707474,949035,980328,181800,356644,991036,899429,558251,109742,132434,175774,350279,178354,611622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]