SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 984015 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 984015 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536578,192091,382749,420520,314974,430409,19036,517629,543544,404043,428793,831305,181940,119137,315417,433439,662428,10345,85748,798844,764224,833116,1009284,530316,745676,12954,864294,771613,108508,525054,60048,509068,161505,76207,990150,377905,333312,447192,311843,1003087,97315,544201,947970,112008,867505,691449,789008,238002,542951,885909,1023406,99658,446173,996471,376335,1036185,29832,230502,202724,1039926) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 984015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 984015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000395s ]