SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50478 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50478 [ RunTime:0.003399s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (685956,689435,115410,640601,389227,983095,269165,657602,688819,459942,575537,956129,985003,419803,104505,402716,815599,882201,537322,125300,528520,477985,929413,1044672,640763,344642,656139,894741,805376,233950,12395,688710,210556,465799,771151,536060,416317,908028,184280,825941,46834,917673,278545,979729,773608,949098,836955,787071,701513,893894,689075,580427,1015368,380186,686463,346795,1043813,147981,422565,471711) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]