SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001732s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 84 LIMIT 1 [ RunTime:0.000901s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 84 [ RunTime:0.003411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352669,62358,711873,253697,430915,282573,266778,618322,519411,65536,654340,659378,922723,307161,278124,382259,516370,56435,289296,204514,422027,250021,256113,570800,579934,863455,39819,905393,31949,613015,73892,940409,178404,902578,660258,193829,71598,642940,48443,747629,277043,500229,958150,477249,731095,2566,986511,826685,259177,262004,47885,357641,104672,987218,522569,672969,862030,721570,384431,103616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 84 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 84 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000371s ]